Append Query for linked tables

[vadharah]

Hi,

I need your help

i have two tables with a one-many relationship:

CompanyDetails - (CompID(automunber), Address, manager etc)
VanUse - (CompID(number), TypeoFVAn, FrequencyUse)


In the 2nd table all fields make up the primary key
i have a form containing all these records and would like to add them to both tables at once through a button(which runs the append query through a macro) on the form. I have created the append queries and when i click the button i keep getting the 'key violations error'...i can do it manually but dont know where im going wrong..

 

[khawar]

There is some violation of validation rule most probably duplicate primary key

 

[vadharah]

There is some violation of validation rule most probably duplicate primary key

Is it possible though to enter 3 records in the second table and 1 in the 1st table at once since its a one-many relationship. That is if one family uses more than one van