how to transfer record of one table to another

[glen]

Hello,

I have two tables "Location" and "Orders"
fields in "Location" table are:
Locid , Location , Deptid

fields in "Orders" are:
Orderid , Locid , Deptid

Now I want to link fields of table "Orders" with table "Location"
So whenever I enter data in table "Location" it automatically update to table "Orders".
I tried to use Append quarry but the problem is append quarry update all record.
But I want that every time I put new record in table "Location" only that record should update to table "Orders".

Hoping you understand my problem.


Thanks

[msoffice.vidyarthi]

you can use the append query itself in a different way,

append into target where coloumn not in (select coloumn from source)

[glen]

By update "all records" I mean that if every time I click append query all previous records of table "Location" will be append to table "Orders" in that targeted columns.
which I don't want.
I want that every time I enter a new Location and Department in table "Location" only that record to append table "Orders".
and all previous records should not copy.

[msoffice.vidyarthi]

Read my first reply in complete and you will understand clearly

OR

Just paste the append query that ur talking about I will try and make necessary changes

[glen]

This is a test db you check and make changes.

[msoffice.vidyarthi]

Below is the query:

INSERT INTO Orders ( Locid, Deptid )
SELECT Location.Locid, Location.Deptid
FROM Location where location.locid not in (select locid from orders)

reply if it worked

[glen]

Well done.
It working nice.
I clicked the star below your post for reputation.
I just want to know for info that if I want to create this criteria in sample query (not in SQL).
then what criteria will be used there?

[msoffice.vidyarthi]

I just want to know for info that if I want to create this criteria in sample query (not in SQL).
then what criteria will be used there?[/QUOTE]


Can you explain what exactly you mean by that

[glen]

I just want to know for info that if I want to create this criteria in sample query (not in SQL).
then what criteria will be used there?

If I use this query type which I shown in image then what criteria will be use there?

[msoffice.vidyarthi]

Not In (select locid from orders)

[glen]

Tested.
worked.
Problem Solved.
Thanks.