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|
Book Shop - Further reading.
Where I can, I have put links to Amazon for books that are relevant to the subject, click on the appropriate country flag to get more details of the book or to buy it from them.
Commercial Software Shop
Where I can, I have put links to Amazon for commercial software, not directly related to this site, but related to the subject being discussed, click on the appropriate country flag to get more details of the software or to buy it from them.
This site may have errors. Don't use for critical systems.