Referential Integrity question 2

[nedstar1]

Hi friends,

I'm still struggling with some of my tables creating additional records, and I believe it is becasue I do not have ref integrity turned on for all relationships. . .

My reason for this is not simple to me - when I turn on the switch in the relationships window, it gives me an error message when I try to save. I know this is due to data in one table not matching up with data in the other table, but this is not explicitly easy to fix.

My question is this: I use a form to do most data entry, with lots of subforms. When the main record is created, and IF I DO have referential integrity enforced, as well as cascade updated records - will this automatically create associated records in the proper tables?

Should be an easy one . . .

TIA

Regards,
Nedstar1

 

[PHV]

Are the subforms properly linked with the main form ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BNPMike]

Access can't create associated records. For that it would need to be telepathic. Referential integrity stops you adding incorrect things, and deletes associated records. Only you can create things.

 

[nedstar1]

Hi Mike,

You just partially answered my next posted question - many thanks for your wisdom. Can you tell me how to accomplish this? My other post is more explanatory - let me figure out how to hyperlink it, and I'll post that link here

Friends, please check other link at:

 

[PHV]

http://www.tek-tips.com/viewthread.cfm?qid=934069

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[nedstar1]

Thanks for both of your help, in various ways. Thanks to BNPMike for the enlightenment about what Access will and will not do for me, and also to PHV for taking the time to post a link for me - that's the kind of Tek-Tips behavior that keeps me coming back. Stars all around.

thread700-934069

Thanks again,

Regards,
Nedstar1