1 2 Previous Next 19 Replies Latest reply on Mar 29, 2016 5:17 AM by beverly

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


      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.




        1 2 Previous Next