LOV with a Dynamic FROM?

[Quoted]         I was hoping that one of the Forms experts out there knows of a way to create an LOV with a dynamic From clause. I have a requirement to provide a list of valid values from a table at a database link specified by the user. For example, the user enters a Link Name on the form and then the LOV for another field is adjusted to use a known table name at the specified database link. I have tried using variables in the from clause and gotten syntax or invalid table name errors. I thought that the Populate_Group_With_Query command might be of use, but I've been unsuccessful thus far.

        Does anyone have an idea as to how I might solve this problem? I can't do something simple like user synonyms because all of our users are logging into one account. (We're using Oracle Applications.) Secondly, the number and names of the links are dynamic, so I can't use some type of case statement to create the LOVs.

Platform: NCR UNIX, Oracle 7.3.4, Oracle Apps version 10.7,

          SQL*Forms 2.3 or Developer/2000 Forms 4.5

        Any suggestions as to how I can meet this requirement would be greatly appreciated. Please feel free to contact me directly at Suzanne.M.Rose_at_daytonoh.ncr.com.

Thanks in advance,
Suzanne M Rose
NCR Corporation Received on Thu Mar 26 1998 - 00:00:00 CET