Way to dynamically refer to field names?

  • Thread starter Thread starter markmarko
  • Start date Start date
M

markmarko

I need to export data from many tables into a flat file as an interim
procedure as we switch from tracking work in Excel to Access.

I have created a temp table to collect the data, which can then be exported.

Basic structure is:
tblSalesOrder
tblSalesDetails (Product, Quantity)
tblSalesCodes (a list of codes which are used in lookup on SalesDetails)

Then field names in the temp exporting table are the same as on tblSalesCodes.

I plan to use recordsets to look at each SalesDetail for each SalesOrder,
and place the corresponding Quantity into the proper field on the temp table.

So for instance, temp table fields might be "Candy", "Beer", "Donuts"

When the code looks at the first SalesOrder, it would see "Beer" (2), "Candy
(3).

I would want be able to find the field to send the quantity based on the
product. Ie, a way to refer to the field rsSalesOrders!Beer dynamically.

Any thoughts?
 
Back
Top