How do you pass a primary key to an append query from a subform?
Example:
Main form – Table Subscriber (subscriber-id – primary key)
Linked (subscriber-id (main form) = ot-subscriber-id (subform))
One to many
Sub form - Other residents (ot-othres-id – primary key)
From sub form...