微软Access -通过不同表格的信息创建新记录。

In my Access database I have an inventory table and a sales table, and a form for each. The sales table needs the same data as in the inventory table. What I want is a simple and easy way where you can create a new sales record by entering in, for example, the barcode for the product in the sales form. Is there a way the form can refer to the inventory table and fill the rest of the fields? In my Access database I have an inventory table