subform from 1:1 related table

[Chris121]

Hi
I have a shipments table and a reason for delay table linked as 1:1 by their primary keys.

I have a form to update the shipment details. For ease of data entry, I'd like a subform with all poss reasons for delay and check boxes next to each.

Each record in [shipments]needs to have a single record in [delays] with the same ID

I've been playing around with this for a day or so, and the sub records keep getting mixed up. How do I keep them together? Can they share an ID?

I started thinking that when shipments were on time, there would be nothing entered in the [reasons]and the id's would get out of sync. I thought so what! BUT when going back through shipment records, the delays were not as originally entered!

Do I need to enforce referEntial integrity with the link between the autonumber primary keys?

HELP!

Thanks in advance, you wonderful people!

 

[Chris121]

ok Folks - I've got it sussed now.
Having both primary keys as auto-number fields is a no-no
I changed the [delays] key to number, instead of autonumber and all is well.

Thanks anyway.

Chris.