Relational Databases - An Example - Linked Form

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:

Enter style:

Call this form 'product' :

Next stage - go on to: search for entries

Other sections are:

• Importing data
• Setting up a form
• normalising the data
• form for many linked tables
• search for entries

Data:

• csv file: nutrition.csv
• database in 1 table: nutrition1tab.odb
• database with 2 linked tables: nutrition2tab.odb