I have a table “ProductsTable” which is a collection of things I sell, and a table “OrdersTable” which is a record of orders people have made.
I want to be able to fill a form to add a new order, and have a sub-form where I can add entries from “ProductsTable” like “Banana”, “Apple”, “Kiwi”, into each record.
Is this possible?