Append / Delete Query

[JTQ911]

I am trying to run a query that appends data into a table.. however, the way im setting it up.....lets say i have a table named Accouts, and under accounts there is #1 to 30. When I try to add a new account through a form, and append it to that, it takes the 31 there nwo are after i added one, and adds it to the 30 alraedy there, creating 61 instead of 31. is there anyway i can take into account for duplicates when im creating a query. im new to databasing, just got stuck with this assignment for the summer, and have no idea what im doing and i dont have time restart after learning normalization. i wish i did, but i dont. if it works it works, thats the bottom line. thanks everyone.

 

[GaryPanic]

look at the attached it shows hopw to limit the append to one record only


you are 3/4 there -

forms![nameofform]![fieldonform]


right in your main form there must be a primary key refer that you want posted into your tables

so you only want 1 record form your main table to go into multi tables
the above little code put in the right place will limit it to one only

 

[GaryPanic]

what this is saying to the programme -i want you to append, righ,t but only a specfic item, and that it's refernce- is in forms ! and the name of the form and the name of the field on the form

you need the ! in the right palce otherwise its garbage for the system to understand