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.

    KevinRoach62

      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

        1 2 Previous Next