Microsoft Access 3C: Lookups / Subdatasheets / Relationships: Subdatasheet in a Form

Relational Means Most Tables are Related:

• A "relational database" means that most (although not necessarily all) tables are related to one another through various lookups.

School Database Example:

When signing out a book in a table called tblSignOuts, a lookup droplist is used to select a student number from a table called tblStudents

You can't enter a student number that has not already been entered, thus eliminating possible errors.

You may also use subdatasheets to make all the details of the student to appear (after selecting the student number, the name, address, grade etc. can be retrieved from tblStudents)

Hospital Database Example:

Patient names and addresses are recorded in tblPatients.

Every time a patient comes for a hospital visit a new record is opened in tblVisits, one of the fields is the patient number (a primary key) which is a lookup droplist from tblPatients

Procedures (like X-ray, examination, vaccinations etc.) are stored in a table called tblProcedures.

After selecting a patient number in tblPatients a procedure is selected from a droplist from tblProcedures.

This website is copyright protected see contact page for details.