Append Query

[anandan.cr@gmail.com]

Hi,

As per the Access File attached , I want to run Append Query to Append "TRNS" Table from Item_Mast! item_Code ,Item_Mast! item_Code, Cat_Mast!cat_Code , Outlet_Mast!Outlet_Code.

But outlet_mast!Outlet_code is in RELATIONSHIP with TRNS table and i wish to am inserting data in TRNS table.

and item_Code , cat_Code , Outlet_Code are key fields in TRNS table.

Pls suggest me ?

 

[Ranman256]

Did you use the Query builder?
Is e target table keyed to prevent your query?