Hi, Use the <@CHOICELIST> (if you are in version 2000)
Create a Select Action which returns the fields you want Let's say AgentID and AgentName Then in the results of the Select action place an <@assign> List this <@ASSIGN NAME="Agents" VALUE="@@resultSet" SCOPE="User"> Then you can place the following choiclist action wherever.. <@CHOICELIST NAME="theEvent" TYPE=SELECT OPTIONS="@@User$Agents[*,2]" VALUES="@@User$Agents [*,1]" SIZE="1" SELECTED=""> Hope this helps Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WiTangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Fogelson, Steve Sent: Saturday, May 04, 2002 10:44 AM To: R:Base User Group (E-mail) 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/ ================================================ 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/
