Build unique tables

[HCB]

I have a reference table and a detail table with multiple rows for each value in the reference table. A sample of each is attached. I need to build a unique table for each row in the reference table with the data in the detail table for the associated reference value.

I am new to VBA programming and would appreciate any help or direction.

Thanks in advance.

 

[plog]

I need to build a unique table for each row

Stop everything. No you do not. Most likely you don't even need to build one table, you probably just need a query.

What do you want the end result to be based on the sample data you provided? Tell me what field names are to be and what data is to go into each.

 

[HCB]

I failed to include the desired results. In the example of source data, there were two spreadsheets(tables in the DB). One is a Reference table containing 4 rows of 2 columns:

• Key - Unique numeric value for each type of care
• Type of care

The other is the detail for each type of care containing 48 rows with 3 columns to reflect the care.

• Type of care Key (link to Reference Table)
• Type of care
• Detail of care provided. This is limited to one column but there would be more to address the individual reciving the care and details of the care. My thought is if I can make it work with one detail column I can make it work for more detail columns.

I want to build a process that will export (excel or .csv) to a different file/location for each type of care with the details for each type of care.

The data structure will remain consistent, but the detail types of care will not be consistent from execution to execution. The volume of different types of care will also vary from execution to execution. Attached are 4 spreadsheets created from the provided sample spreadsheets representing query results desired to be exported to the different locations.

Thanks in advance for any guidance.