Does RI with nullable FKs really work?????

I've taken RI off all my relationships in which the foreign key can be null,
because Access doesn't seem to allow a FK to be null if RI is defined on it.

I'd be amazed if Access did not permit RI on nullable FKs, so first thing is
to ask the experts here: does it?

If the answer is "yes", then I'll post the details of my own situation, in
which I can't leave a FK null if RI is defined on it.

thanks.
.

Relevant Pages

  • SQL query correctness/efficiency of my query
    ... pk in item master and the foreign key in the other 2. ... I am using Oracle 9i. ... Thanks Rob ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Re: all foreign key should have index?
    ... I'm not sure I want my rdbms generating a 5GB index on ... my foreign key when I might not require it. ... http://sqlserverfaq.com - free video tutorials ... Prev by Date: ...
    (comp.databases.theory)
  • Re: One-to-Many Help
    ... >properties (Customer, etc) that I put in 10 different table columns. ... new business requirements require that each PN be provided ... CN <foreign key to Characteristics> ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
  • Test if Data for a Field is UNIQUE
    ... I want to create a Foreign Key and base it on an existing field ... Can someone please share SQL that can be used to determine if the ... Michael42 ... Prev by Date: ...
    (comp.databases.oracle.server)