one to many relationship

[kes]

hi,

I have 1 table with one to many relationship to other two tables (added a picture).
I thought on creating a form with subform to enter the data, but
the problem is that I need first to enter into the supporters table and to the Serial numbers table before entering the Error table...
that's causing problem cause I can't enter first to them because I didn't created an Error ID to link to them.

what can I do?? (hopefully you understand my explanation)

 

[Pat Hartman]

Looks like your relationship is backwards. The supportersID and serialnumberID belong in the errors table. Remove the errorID from the other two tables.

PS - Naming all your primary keys ID is poor practice. I know that the Access wizards do that but they do it because they need to come up with a name for the column BEFORE you have given them the name of the table so there is no way they could generate meaningful names. You need to give the IDs some meaningful name so that a stranger looking at your schema can match foreign keys to primary keys without actually reviewing the relationship diagram.