I can't get a simple database to work in Access 2007

[MOS was 71331]

I'm unable to convert an Excel table listing my recorded books into a simple
Access database.

The Access database would have three tables: Authors, Media, and Titles.

The Authors table would have two fields, ID and AuthorName, with ID being
its key. There are about 180 author records.
The Media table would have two fields, ID and Medium, with ID being its key.
There are 2 records: "CD Rom" and "Tape cassette".

The Titles table would have four fields: ID, Title, AuthorID, and MediumID.
AuthorID would be the ID in the Authors table for the book's author.
MediumID would be the ID in the Media table for the medium on which the book
is recorded.

The Authors and Media tables looked as I expected after I populated them.

When I tried to create the Titles table and have the AuthorID link to the
Authors table, Access says "The table must be saved before relationships can
be created. Save now?" When I answer "yes", Access says "The table could
not be saved."

I can't get past this point.

What am I doing wrong?

 

[KARL DEWEY]

First create the tables without linking. Make the 'ID' field of each of the
three a primary key. Save.
Click on menu TOOLS - Relationships. Select the three tables. Click on the
primary key field (is bold) and drag to the foreign key field as here --
Author.ID --- AuthorID
Medium.ID --- MediumID
Set Enforce Referential Integerity and Cascade Update Related Fields
Save.

Use form/subform for data entry/display. Link form/subform Master/Child
links on the ID - xxID. Use a combo box on subform to pick author and
medium on the respective subform.