I'm doing some work on a simple inventory/kit database. I have a table with all of the parts available and their attributes. I have a table to hold descriptions of all the different types of kits. Within the Kit table I've put a multivalue list field to hold all of the parts that go in each kit. So far, so good. (?)

I've also been given a bunch (in other words, too many to do by hand) of tables, 1 table per kit that has a row for each part used in the kit, usually around 30 parts/rows. I need to insert the parts from these tables into my new Kits table parts field.

I've learned that I cannot do a simple "INSERT" and do all of the part numbers in one go, but can do them 1 at a time:

INSERT INTO Kits ( [Part List].[Value] ) Values ( partNumber) WHERE ID = kitNumber;

What are my choices for getting the part lists imported? Macro? VB? I'm not a VB programmer but could cannibalize an example if I had one. Macro's are totally new to me.

TIA

Janene

I've put a multivalue list field to hold all of the parts ...

In this case, I would avoid the a multivalue list field and use a child table with a record per item.