Advanced Lookup With Variable

[#1]

If an advanced lookup has several lines to look for data and the same lookup would be repeated except for the word or phrase being looked up, a lot of time is spent in repeating the lines in a new lookup.

In my particular case, our database is over a decade old with a lot of people doing things their way.  Therefore, the desired data may be stored in any one of 12 fields.

I would like to see if the gurus at Swiftpage could figure out a way to add a line to an advanced lookup that contains a variable (whatever the user needs to find) and the next 12 rows would contain a pointer to that variable field.  

A lot of time would be saved to retrieve information out of a database.  Besides, isn't that what a database is all about - being able to retrieve data?

Thanks for your consideration.