Thank you very much, I am trying to use a form but have the Orders form and then Orders Stock as a subform so I don't think it is possible to adapt the properties of a subform?
Hello there,
Apologies if this has been posted before but I am unable to find a solution.
Say I am trying to create a database to record sales and I have the following tables (simplified for easier posting here):
Orders tbl:
OrderID (Primary Key)
Date
Stock tbl:
Product Name (Primary Key)...