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