[AccessD] MAny-To-May

Susan Harkins harkinsss at bellsouth.net
Sun Mar 19 10:18:16 CST 2006


Rocky, check the updateable query article. There's a rule in there about a
one-to-many-to-one, or it may be many-to-one-to-many -- I don't remember. 

Susan H. 

Dear List:

The problem comes when trying to create a new job.  Since there's no PK yet
for the job I get an error "cannot create record; join key (to the
JobEquipment table) is not in the recordset.

Indeed if I put a debug statement in the BeforeInsert event of the sub-form
the PK of the Jobs table is still null. 

How does one work around this problem?




More information about the AccessD mailing list