You will have to use a SQL menu. this menu will query the field table. please use the following SQL that will give a list of fieldid and field name for form Form11. change it accordingly.
select fieldid,fieldname from field where schemaid = (select schemaid from arschema where name = 'form11')
HTH
-sam
On 4/27/06, Veeral J Oza <[EMAIL PROTECTED]> wrote:
**Hi,Here is what I am trying to do, I have a menu from which I select a form name, On selecting a form name, I have all the fields name populated on another menu. After selecting a particular field i want to store the database id of that field in a hidden character field.E.g.Menu1->MyApp:Form1Menu2->Form1:Fieldnamezcharfield->databaseid of fieldname selected in menu2.Environment:ARS 6.3SQL 2000 ServerSo how do i retrieve the databaseid of the fieldname selected?Kindly help!!Regards,
Veeral Oza
__20060125_______________________This posting was submitted with HTML in it___
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
__20060125_______________________This posting was submitted with HTML in it___
