I think what you're looking for is Many-to-Many

Hi Melvin
Are you sure that you have to store multiple funding codes in Bluetag OR do you want to link them to your Fundsourse table?
John

Thanks Adam. I have it using the many-to-many.

I have it working using the many-to-many as Adam suggested. 'However I don't have a foreign key in the Bluetab table for the fundingcode table. So, I have two questions, 1. Do I need a foreign key for the fundingcode in the Bluetab table? 2. I want to be able to duplicate records with a button to include records in the children tables. Right now there is no relationship between the fundingcode and bluetab tables. I have a junction table that is making a many-to-many relationship. To make the duplicate record that will copy certain fields in the bluetab record and the children records do I need a one-to-many relationship also?
We can receive 1 to 500 items of the same equipment. I want to enter the basic item information and then duplicate the record for however many quantities we received and then manually enter the unique information for each item. Once the children's information is entered it will not change.