I have a query based on two related tables. tblParts has a foreign key that is related to the primary in tblSuppliers. I want to build a query that will display parts from a particular supplier. tblSupplers has two fields, ID and SupplierName.
Is it better to use just the tblParts and base my criteria on the SupplierID in that table or should I include tblSuppliers and base my criteria on the text of supplierName?
Thank you