Append Qry - destroys d/b

[GaryPanic]

Guys ...
what i wanted to is use a number(Policyno) in my table (Quotetbl) as the primary number in another table Compliancetbl

so in my simplist view i have create a new record and get next number function from my system table
then Save
then use a append qry to make my new record in the complance table the same number policyno
works ok ..
however it corrupts the whole d/b and you lost network and the abilty to get to code


first of all why - second whats the fix , thirdly is this the best way to achive this ....

 

[Balr14]

So, you are appending one record to an existing table? Maybe your append query isn't specific enough and is picking up some extra records?

 

[GaryPanic]

i have tied it down - will retry but I am sure i did
Save
and the qry tied to the form