View Single Post
  #10  
Old April 16th, 2010, 03:33 PM posted to microsoft.public.access.tablesdbdesign
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Access not enforcing referential integrity!!!

Assuming the Link Child and Link Master properties of the subform control are
properly set, as John pointed out.


Fred wrote:
Danny,

You mentioned entering on a subform in your last post.

Assuming that the subform is actually being used as a subform, the PK value
of the parent record is automaticaly loaded into the FK of the child record
when the user creates a new record in the the subform.

This is also the common way that this issue gets taken care of.

Fred


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201004/1