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.