Best way to relate these tables.

[rosco2382]

I am trying to design a database for my department to better track our PC's and tablets. I have made three of the tables out of the 4 I believe I will need. I am having an issue to relate the three that I do have to one another.


We have roughly 30-35 branches with about 4-6 branches that have a machine shop associated with it. So I assumed that I should create a separate table for the shops, a branch table and an employee table. How do I relate them so that when i add the asset table it will be able to do what I need it to do. As of right now, when I run a report just to see a list of all employees, it will only show employees associated to a shop. Not my entire company. If someone could help me or guide me to the right places I would be so greatly appreciated.

[June7]

Show the report RecordSource query. I suspect you have INNER joins.

INNER join requires related records in both tables on each side of the join for any records to display.

[orange]

There is a free data model here related to managing IT assets that may be helpful.

Good luck.