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...