Building a Relationship

[Daniel Lamb]

I have a database for files stored on CD and I am trying to link two tables
called Media Resources and File Info.

Media Resources has the following fields
ID
Disk
Capacity
Storage Location

File Info has these fields:
ID
Disk
Name
Bytes
Delete Date
Available off-line

I want to create a relationship using the ID field. Each name in the Disk
field of Media Resources is unique. Records in Disk of File Info are to
have many duplicate entries for more than one file is on a disk. By
building a relationship of the two tables, I want to be able to use the
number values in Media Resources Capacity for calculations involving file
sizes under File Info Bytes.

I've tried to establish this relationship in the builder. It's one-to-one
for there are no other tables in the database. I think the join should be
All records in File Info and only those in Media Resources where values
match. I can not set a join that will satisfy Access for enforcing
referential integrity to carry out cascade updates or deletes of related
fields. I receive the error 'Invalid field definition 'id' in definition of
index or relationship.'
Once I get a relationship with enforcing referential integrity that works, I
should be able to add or delete records based on queries, yes?

Thanks.