Append Query Help! 1

[medreports2]

I have been doing some very repetitive work for awhile now that I believe can be solved with an append or make table query of some sort. Please help!

My situation:
I have 2 data tables; [Master] And [Accessory Detail].

[Accessory Detail] contains 5 records, 40 fields
[Master] contains x records, 50 fields


3 fields from [Master] are queried from various records meting a specific criteria. (Category, Manufacturer, Model).

What I need to do is insert each combination of (Category, Manufacturer, Model) into a new instance of the 5 records in [Accessory Detail], creating a set of 5 records for each (Category, Manufacturer, Model) combination.

Thus if my initial select query of [Master] returned 10 records, when I was finished appending records to [Accessory Detail] I would have 50 records in [Accessory Detail], with 10 subsets of data made up of the original 5 records in [Accessory Detail] with the 10 (Category, Manufacturer, Model) fields inserted into specific fields in [Accessory Detail]

Please write back if I have not made myself very clear. Please help!!!

 

[Blorf]

Hi. Not super clear, but taking a guess

You have a table of 5 records and a table of 10, and so you want 50 records appended to another table yes?

If so, in a query, bring in both tables, and do not join them, select the fields from both tables you want, and execute.

With no join, you should get your 50 records.

ChaZ