I have my app talking to the MS SQL database. meaning I can retrieve data from it. I have an Office table. and it has a column called 'Marketing' that is a foreign key to the marketing tables primary key.
so I was have trouble and I set up a test environment on mac using Locomotive. I set the tables up the same way as the MQ SQL server.
here are the models
