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

relation 0:1

P: n/a
How can i model relation n - 0:1 in access? by default it is n - 1 but
i dont want the other side of association to be obligatory...

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Marcin wrote:
How can i model relation n - 0:1 in access? by default it is n - 1 but
i dont want the other side of association to be obligatory...


Not sure I understand the question. If in a one-to-many relationship we
describe the record on the "one" side as the parent there is never a requirement
at the engine level that any child records on the "many" side exist. So you
simply don't create them.

If you want child records that have no parent simply make the foreign key that
would ordinarily be related to a parent record a "Required = No" field. Often,
the foreign key is part of a multi-field Primary Key in the child table, but
that is not a requirement and in this case you would have to make sure that it
wasn't. The you simly leave a NUll value in that field.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.