Appending Data

[AccessProgrammer]

I have a clarification to be sorted out. I have a database where-in there exists a table (Table x) with following fields:
Part Number
Description
On hand Qty

Now, I have to append a new table (Table y) to old table (Table x) in the same format. But, I have to append only the part numbers which are not available in the old table (Table x) from Table Y.

How to set this append query ?

Please share the way out.

Thanks
AL

 

[AccessProgrammer]

For Eg:
If Table X has part numbers 1A1, 1A2, 1A4, 1A5
Table Y has part numbers 1A1, 1A2, 1A3, 1A4, 1A6, 1A7

After I append, the part numbers should be 1A1,1A2,1A3,1A4,1A5,1A6,1A7

Please help me with a way out.

 

[dylan_dog]

If part number is your primary key the append query will report an error and it will append only the part numbers that don't exist in your first table.

 

[AccessProgrammer]

Thanks Dylan !
I forgot to ask for the below clarification ...

In case if it is a combination ... eg: A Table has Emp Name, Designation, Location.
When I have to append another table in same format ... append should not upload a combination of Designation and Location which is same.

i.e if Manager from Peoria is already available it should not append another Manager from Peoria but it should append Asst Manager from Peoria or should also append Manager from Chicagao.

 

[dylan_dog]

I've never tried it, but maybe a composite key from those two columns?

 

[dylan_dog]

Composite key, tested

 

[AccessProgrammer]

Dylan, thanks a lot, Buddy !!!
I'll try this ....