Hello Elise,
First set up a convenient naming convention. For example: if you have a product table and a billing table, then think of initials or acronyms for each one. For Product table a good one is Prod and Billing would be Bill. When you create a relationship between both, QB will create its own naming convention that some times doesn't work for me. So, for fields in the Product table I create the fields with names like: Prod_Name, Prod_Type, Prod_Description.. for the Billing it would be like: Bill_Date, Bill_Price, Bill_Quantity. When you have multiple tables with multiple relationships, having those acronyms can right away help you identify where that field comes from.
Hope that helps.
