Cascading Update Problem

[neileg]

The only way you can populate an FK with the appropriate vale without a form is if you have table level lookups defined. No one in their right mind uses table level lookups because thay cause all sorts of trouble.

 

[Pat Hartman]

That doesn't do it either. ONLY form/subforms can automatically fill the FK because that is the only situation where Access knows what the value should be. If you just opened the child table by itself, how would Access know what the value of the FK should be? It wouldn't, so you would need to supply it. With the form/subform master/child link, you are telling Access to take the PK(master link) of the main form and place it in the FK (child link) of the subform when a new record is created.

 

[neileg]

Of course you're correct, Pat. I think I short circuited the process in my head!