Hello, thanks in advance for any help. I have been given the unfortunate task of creating a database for a restaurant. I understand the form concept of being able to have the primary key and foreign key data entered simualtaneously through forms. However, I am entering alot of previous data into the database first without the use of forms. I have a table called Products wityh 145 records that lists all the products with there suppliers and product code and quantity per unit....etc. I then created a table called Inventory that containts on hand and cost fields. The products table has a primary key ProductID set to autonumber, the Inventory table has a foreign key name ProductID set to number. I linked the primary key to the foreign key in the relationships layout. My question is how do i make the productID of Products table autofill the Inventory's foreign key without having to copy and paste?