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:

linked form 1

We want to add a Subform to show the 'byWeightQuantities':

linked form 2

For the subform we select all the fields in the 'byWeightQuantities' table:

linked form 3

We use the barcode fields to link the tables:

linked form 4

I used the following arrangements:

linked form 5

I allowed the entries to be edited:

linked form 6

Enter style:

linked form 7

Call this form 'product' :

linked form 8

Next stage - go on to: search for entries

Other sections are:

Data:


metadata block
see also:

 

 

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.

Copyright (c) 1998-2017 Martin John Baker - All rights reserved - privacy policy.