I have a table of field names (tblFieldNames) with a field named [strFieldName] and want to look up the data in a second table (tblNames) using the field name from the tblFieldName table.
So: strFieldName from tblFieldNames has a content value of "[strName]" (with or without the brackets - I'm easy here)
I then want to evaluate the content of [strFieldName] from table tblFieldNames looking it up in tblNames.
Hopefully my question makes sense??? If not I will try some more examples.
Any one got any ideas?