//This table is created by pulling FieldName(Thing), then parsing that fieldname to create the Field_Ref field WHERE Thing starts with 'pri'
I want to a table that automatically generates the Field_Name list in the load statement, based on the Field_Name from the PriList table, and which pulls VALUE from the MASTER table based on all rows in the PriList Field_Name.
//loop through Field_Name in PriList, populate those in the following load statement:
Drop Table Master;
I've tried several types of loops, researched LookUp, but the solution continues to elude me.