Cascade Relationship

A

AHopper

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
 
J

Joan Wild

AHopper said:
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.
Click to expand...

It sounds like you are doing this in the frontend. Open the backend mdb
where the tables are and do it there.
 

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

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Adding data to MS Access from csv file 0
Weekly Report 2
Word isn't capitalizing the first word of each sentence 2
Cascade deletion of referral tables 1
Linked SQL Tables don't report Cascading Updates and Deletes 2
Enforcing referential integrity across databases 4
ASK Field Formatting 1

Top