MS SQL (legacy) relations not working.

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