I have a database that is split when I try to create a One to Many
relationship between tables I am not allowed to select the cascading options.
I have tried with different table combinations but none have allowed these
options.
Is there an option in Access that I need to enable?
Thank you in advance for your help.
Allan
Joan Wild - 13 Jan 2005 23:30 GMT
> I have a database that is split when I try to create a One to Many
> relationship between tables I am not allowed to select the cascading
> options. I have tried with different table combinations but none have
> allowed these options.
It sounds like you are doing this in the frontend. Open the backend mdb
where the tables are and do it there.

Signature
Joan Wild
Microsoft Access MVP