Relationship issues

[asweisman]

I am having trouble relating the contacts table with the company table. Right now the city and company tables are set up and working (i think), but the Contacts table is not showing information about the cities even though it is connected to the company table. In other words, I would like for each contact to have a direct connection to not only the company, but also the cities table. For example, when I go to the Contacts table, I can pull up a contacts name and company, but I don't know which cities he is in. If someone could point me in the right direction that would be great. The relationships report is attached to the post.



Thanks
Aaron

[RuralGuy]

I'll start by asking why is there a CompanyID and a ContactsID in the Cities table?