How to Set Reference Table as Dynamic based on some field data

[subbu bugorg]

Hi,

I see it is possible to filter out results returned by a reference qualifier based on some criteria. This is like we set Reference field looking up table "X" which has 10 records and creating a script include which returns query that returns only some of them.

My question is about dynamically creating a reference to table X, where X comes from another reference field that references sys_db_object.

Ex : User looks up a table from a reference field, say sys_processor, now another field should show records in sys_processor, but this is not a fixed table. Any idea how can I achieve this?

[RaghavSh]

You can get the record in same script include and display record as string in field B based on table name.

[subbu bugorg]

Thanks for your time, not sure if I am not clear enough. Once I get hold of A value in script include called by ref qualifier of B (I am unsure whether we can have a ref qualifier to return value for a string value similar to a reference field), I cannot do any scripting and return string data to show on field B. 

I want users to select the table, and also the record on selected table. I can get the table name in script include, but the answer for record should come from user.

[RaghavSh]

If the table is not fixed, then it may not be possible to achieve.