specifying a fieldname from user input

[pmusaev]

how do you target a specific field based on what a user has inputed into a field? basically, i am able to generate a field name based on user input; now i need to spit out a few other fields that are relevant to what the user input. ... does this make any sense?

so if the user input "007" i have a script that creates the following text string "007_st" and there is a field name in my dBase called "007_st" and i would like to display it's value.

[Vaughan]

Are you familiar with relational databases? It sounds like what you want to do with fields can be done more easily with related *records* (and be easier to maintain as well).

Try doing a forum search for "filtered portal" or something similar.

[pmusaev]

what's the jist? i am slightly familiar with relational databases, but not sure on how far their power can extend. could you explain how i could achieve this easily? maybe with a self-relatioship?

[pmusaev]

i need to access a fieldname based on a dynamic value... that's how i could summarize it

[Vaughan]

Tell us *what* you want to do, not *how* you want to do it.

[_ian]

You want the GetField function. so if in your example you had a global field named UserInput that contained the value "007_st", you would code it as GetField(UserInput). This would return the value that is in the field named 007_st.

Ian

[pmusaev]

exactly, thank you Ian! *remembering GetField*