Append query

kabir_hussein

Registered User.
Local time
Today, 11:52
Joined
Oct 17, 2003
Messages
191
Hi i have an append query which i need some help on. Due to reasons i have two tables 1 stores all the items ordered and the second table is used for adding new items which in turn is linked to an append query and is saved on the first table.

However i now have a problem in making the append query work as it always says 0 append.

this is because the query thinks there is no new data but how can i do something that would differ the two tables.

I have uploaded a e-r screen shot of my tables. thw two tables i am stuck on are tenderlink and tendernew

tenderlink being the main table.

thank you
 

Attachments

  • er.JPG
    er.JPG
    55.5 KB · Views: 163

Users who are viewing this thread

Back
Top Bottom