Table relationships problem

J

Jo

I've just redesigned a flat database into 3 seperate
tables, linked in a one-to-one relationship with an
autonumber in each table as the primary key. There are no
orphen files, and I have enforced referential integrity.
I can even select cascade delete without any trouble.

When I try to select cascade update I get an error message
that reads "Invalid field definition recID in definition
of index or relationship"

Can anyone suggest any solutions?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top