Friends,
I have two tables, with their forms. The one is Orders, which has the fields: [Order ID], [Suppliers Company], [Product], [Quantity of product], [Price per Unit], [Total Price] and [Order Date].
I also have the Suppliers Form which has the fields:
[Suppliers ID], [Company Name]...