JFD Art - 9 - Using Forms

John is very pleased with the information in the database but would like to be able to view all the information about a painting and artist on 1 screen.  This problem can be solved by creating a form.

You might wonder - "Why don't you store all the information in 1 table?"  Don't forget that we don't want repeated information (e.g. Artist Details) in the same table.

STEP 1 - START THE FORM WIZARD

STEP 2 - SELECT THE FIELDS TO APPEAR ON THE FORM

STEP 3 - VIEW THE FORM

Artists are displayed in the top half - their paintings in the second half

1  Introduction     2  Setting up tables  3  Inputting Data
4  Creating Relationships  5  Queries - single fields 6 Sorts
7  Queries - Multiple Fields 8  Queries - calculations 9  Forms
10 Reports  11 Graphs