Table Relationships

[Juli]

I have an inventory database with 1 main inventory table
and 7 specific tables.

I have created a relationship where the fields in the 7
specific tables relate to fields in the main table.

I have input forms for the data input. When I first
created the setup, the very first record that I entered
into one of the specific tables updated the main table
fine, but an successive data is only in the specific
table and not updated into the main table.

Any suggestions?

 

[GVaught]

We need to see how you related the tables and what primary key and foreign
key values you have assigned to each table. This will help us help you. Type
in the data, don't attach any images or your database. Give us enough fields
to get the just of your setup.

 

[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