conditional many to many relationship

[datafahfur]

We have a moveID field in TableA that generates an autonumber that is used to form a relationship with the same field in a junction table. After the MoveId is created in TableA is there a means of automatically inputting the same MoveId autonumber in the MoveID foreign key in the junction table.

 

[dhookom]

A junction table should have more than one field. If you place the MoveID in the table, what would you expect to put into the other field(s)? I would expect that you could use the After Insert event of a form bound to TableA to insert the MoveID into the junction table.

I don't understand the justification for doing this.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.