Table Relationships

[Juli]

I used the relationship button and related fields in the
tables that way.

This is a library inventory database - I have 7 secondary
tables for: Hardback, paperback, cd, cassette, dvd, vhs
and magazine.

The Main inventory table has all of the combined fields
from each of the 7 secondary tables.

Using the relationship button I opened each secondary
table and related the fields to the matching fields in
the main inventory table.

Example: title - title
Artist - Artist/Author/Starring
Donated by - donated by
Director - director/conductor
Publisher - Publisher/label/studio

The fields with multiple items match single item fields
in the secondary tables.

So there might be 3 secondary tables with fields relating
to a single field in the main table.

There are also at least 4 fields that occur in each of
the secondary tables, so those fields are related between
the main table and 7 secondary tables.

I didn't create any primary or foreign keys and did not
select "enforce referential integrity"

I am sure that you can tell that I am still very much a
beginner here.

Appreciate the help