Need help with subform sync

[ksaab]

Hello,

I am really stuck - I have a form of companies with a subform of contacts.

In the DB (SQL) the tables are related one to many CoKey to ContactCoKey.

How do I synch these so any new contact record automatically gets a "new" ContactKey as well as the related ContactCoKey?

Thanks,

 

[WayneRyan]

K,

Either use the Master-Child links and let Access do all of the work.

Or, set the DefaultValue for the Child Key to:

Forms![YourMainForm]![Cokey]

Master-Child link is better.

Wayne