I have a table that will contain data for a delivery manifest that includes prescription number, employee enter, and delivery site. In tbl 1 I will include all these fields. In tbl 2 I want to have the date, employee enter and delivery site. I want to be able to enter tbl 2 information on a form once and apply those fields to tbl 1. The intent is to streamline the data entry process from having to enter in my form everything in tbl2 each time I enter a prescription number in tbl1 as there could be 30-40 entries of rx # per site-date and employee. Report output should look like this: Auburn North Pharmacy, Bob M. 1/20/2016 rx's: #1234, 1444, 5666, 7777, 1940, 4490. The delivery manifest will have the pharmacy name, date, and employee who entered and a list of the rx#'s. I am only intermediate ACCESS user so a lot of code probably would be over my head.