I was looking for a way to have access automatically add records to a table. I wanted to have a form that I input a quantity of items purchased and a price for each. I then want to add a single record for each item (quantity purchased) with the price in a separate table.