G
Guest
your an absolute legend Jeff, that is basically what i
already had but its good to know i was on the right track.
I didn't have a primary key in supplier as i had a many-to-
many table.
Your right, one specific part cannot come from two
suppliers, One part can be supplied by different
suppliers, so a tire can come from supplier 1 or
supplier2, not both at once as i may have made out!
i think my problem is that each different supplier gives
the parts the SAME part number...
Thanks again for your help
Alex Marchant
An update
**********************************************************
I just put everything into tables, seems to work - made a
quick auto form to see if i could enter details - get msg
'cant add record(s); join key of table 'tblIssue' not in
recordset'
what does this mean?? how can i change so that a form will
enter details to all tables?
cheers jeff
already had but its good to know i was on the right track.
I didn't have a primary key in supplier as i had a many-to-
many table.
Your right, one specific part cannot come from two
suppliers, One part can be supplied by different
suppliers, so a tire can come from supplier 1 or
supplier2, not both at once as i may have made out!
i think my problem is that each different supplier gives
the parts the SAME part number...
Thanks again for your help
Alex Marchant
An update
**********************************************************
I just put everything into tables, seems to work - made a
quick auto form to see if i could enter details - get msg
'cant add record(s); join key of table 'tblIssue' not in
recordset'
what does this mean?? how can i change so that a form will
enter details to all tables?
cheers jeff