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