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.
English
English (United States)
Deutsch (Deutschland)
German (Germany)
Français (France)
French (France)
italiano
Italian
日本語
Japanese
한국어
Korean
Português
Portuguese