AnsweredAssumed Answered

Relational database setup not relating! Need help with Relationships or the way I did Tables etc.

Question asked by KevinRoach62 on Mar 25, 2016
Latest reply on Mar 29, 2016 by beverly

I setup a database based on my Microscope Business. I have Customers and their info, from a customer I can open a work order. Next I can log expenses, mileage and log repair parts used or ordered. I set it up so I could have multiple entries. Now this is were I may have made a mistake in the setup being a newbie to relational databases, I setup individual databases and loaded them into Relationships.

 

When I have entered 3 different customers I can see the Work Order from any of the 3 customers and should be tied to just one. Same happens with the other data from expenses, mileage and parts.

 

I am also have trouble getting fields from other databases(tables) to show data on different layouts.

 

Thanks,

Kevin

Attachments

Outcomes