I can think of 5 ways to do this off the top of my head, and if you posted
this question on the wiTango list, you would probably get 20 different
answers.
One way is to use the SELECT HTML command in a database action to build your
selection menu. In HTML, the Select command gives you a pulldown menu. You
could do it something like this.
[select name="contact_status">
[@rows>
[option value=[@column users.contact_status>>[@column users.contact_status>
[/option>
[/@rows>
[/select>
Troy Sosamon
>===== Original Message From [EMAIL PROTECTED] =====
>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/
Troy Sosamon
Denver Co
[EMAIL PROTECTED]
================================================
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/
