Value List Based upon Field Name

[mkohler28]

I am trying to display data from multiple fields in multiple db's from multiple files on to one value list which is based upon another related value list's condition which is a combination of the file name & field name.

 

I have a db called 'Search Data' that contains records of all searchable file and field names

 

Example:

 

"FileName"-"FieldName"

Locations-CompanyName

Locations-ZipCode

Contacts-ContactName

Contacts-Email

Invoices-InvoiceID

Invoices-Terms

etc.

 

A user chooses "Company Name" from the Search Data Valuelist, what I'm trying to do is then display all the data in another value list based upon the file name and field name.

 

I am trying to avoid making a separate db to hold all the data, rather display it directly from the target db itself..any ideas on how to set up this kind of relationship?

[Weetbicks]

Look into the GetField function, I think its going to be needed if you want to get the contents of a field, the name of which youve specified in another field.