This page follows on from normalising the data page.
Having normalised the database we now need to change the form so that it can show the complete information for a product including the linked table. It therefore needs to show upto 2 byWeightQuantities. This will allow us to enter the complete information for a product in one screen.
I found the best way was to run the 'Form Wizard' to create a now form from scratch.
As the main form we select all the fields from the product table:
We want to add a Subform to show the 'byWeightQuantities':
For the subform we select all the fields in the 'byWeightQuantities' table:
We use the barcode fields to link the tables:
I used the following arrangements:
I allowed the entries to be edited:
Call this form 'product' :
Next stage - go on to: search for entries
Other sections are:
|Correspondence about this page|
This site may have errors. Don't use for critical systems.