Querry criteria better practice

[lefty2cox]

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

[June7]

Sorting and filtering is best done on numeric keys. However, if you want an alphabetic order then must use text for sort. Include tblSuppliers if you want to see name.

[orange]

How will you determine the supplier? By name, by id, on a form?

Since tblParts has a FK to Supplier, you may be able get all you need from tblParts, if you know the supplierid.

Need a little more context re your setup.