thanks for your answer , i read this link but i did not undestand it .
i am not profi in access , please clear the answer for me
i want to know when i make a invoice i want to know how can i select the product from first table and fill the other fields in invoice table to calculate the stock...