Hi Steve,
Take a look at the attached dropdown.txt, may give you some ideas.
Brent Skean
Current Solutions
-----Original Message-----
From: Fogelson, Steve <[EMAIL PROTECTED]>
To: R:Base User Group (E-mail) <[EMAIL PROTECTED]>
Date: Saturday, May 04, 2002 10:41 AM
Subject: Drop Down in R:Tango
>Thanks for the previous suggestions.
>
>I have a table of salesagents and a table of customers. Both will change
>constantly.
>
>I want to be able to enter the salesagent for a customer from the
salesagent
>table.
>
>In the R:Tango tutorials, It tells how to enter "static" drop down lists.
>But can I select a salesagent while entering a customer record, from the
>salesagent table and enter the salesagent id or name into the customer
table
>with R:Tango using a drop down list or some other technique?
>
>I would need to be able to do this on an update as well.
>
>If so, how?
>
>Thanks
>
>Steve Fogelson
>Internet Commerce Solutions
>================================================
>TO SEE MESSAGE POSTING GUIDELINES:
>Send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: INTRO rbase-l
>================================================
>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
>In the message body, put just two words: UNSUBSCRIBE rbase-l
>================================================
>TO SEARCH ARCHIVES:
>http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
Some examples of dropdown lists
Use DBMS action to create local$technicianlist, a list of single values
If local$vtechnician has a value then the dropdown list of
local$technicianlist will default to local$vtechnician
<SELECT NAME="technician">
<option selected value="@@local$vtechnician">@@local$vtechnician
<@ROWS ARRAY=local$technicianList>
<OPTION VALUE="<@col num=1>" <@ifequal value1='@@local$vtechnician'
value2='<@col num=1>'></@if>><@col num=1>
</@ROWS>
</SELECT>
Use DBMS action to create local$locationlist, a list of double values (a location code
and a location)
<SELECT NAME="locno">
<@ROWS ARRAY=local$locationList>
<OPTION VALUE="@@local$locationList[<@CURROW>,1]">@@local$locationList[<@CURROW>,2]
@@local$locationList[<@CURROW>,1]
</@ROWS>
</SELECT>
Same as above with default to a specific location code
<SELECT NAME="locno">
<option value selected="local$vlocno">@@local$vlocno
<@ROWS ARRAY=local$locationList>
<OPTION VALUE="@@local$locationList[<@CURROW>,1]">@@local$locationList[<@CURROW>,2]
@@local$locationList[<@CURROW>,1]
</@ROWS>
</SELECT>
Also, can use CHOICELIST metatag
