Add query by condition

[Phalanx]

Im having problem in making the condition for an adding query to add records to a table, the condition is that this record doesnt exist already (equal on all columns), how do i create this condition? an example would be great!

 

[ColinEssex]

Presumably you are using a form to enter the details. Why would you need an append query?

Col

 

[Phalanx]

After iv added some details in a form for 1 table, the query adds details for 2 other tables, i just wanna kmake sure it wont readd the same details over again...