By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

How to enforce the one to many relationship?

P: 10
Hi there,

I have two tales that are in one to many relationship. For every ewo (enhanced work order) record there is at least one ewo status record.

How do you enforce this constraint in access?

Right now, I have ewo status table as a subform and have tried to set the fields of ewo status table to NOT NULL within the table. However, when there is no focus on any of the field, the user can save the ewo record without entering an ewo status record.

Thanks a lot.
Dec 21 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,417
Set up the links you require in Tools / Relationships.
Good luck and Welcome to theScripts :)
Dec 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.