Relational Databases - Example - Linked Form

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:

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

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.

Can this page be improved?

Please send me any improvements to here. I would appreciate ideas to make the pages more useful including error correction, ideas for new pages, improvements to wording. It helps if you quote the full URL of the page.

progam

I am working on a project which uses these principles, if you would like to help me with this you are welcome to join in, here:

for kontent: http://sourceforge.net/projects/kontent/

This site may have errors. Don't use for critical systems.