Each Lookup To Supplier field in the Products table points to a unique supplier ID in the Suppliers table, so you can look ...

Each Lookup To Supplier field in the Products table points to a unique supplier ID in the Suppliers table, so you can look at product and supplier information together. For example, to add Pepper as a new product from Pavlova Ltd., you simply enter Pepper in the Product field and PAVL in the Lookup To Supplier field. Now you can list Pepper from the Products table together with all the Pavlova, Ltd. distributor information in the Suppliers table.