Create

Here is the Product Table with all the records

This is the supplier table with all of the supplier codes which are related to the supplier codes in the product table.

Here is the relationship (one to Many) of supplier code in both tables

Here is the report of the product Table

Here is the Supplier Table

This form is the form that will be used to input data into the supplier table

The form is the form that is used to input data into the product table

These are the buttons that are used to navigate the interface

This is the results of a query that is using the criteria detailing products that are less than or equal to 500 Dollars. The Query uses the relationship to bring up the supplier name even though that data is in a separate table.