Celia, I'm sure there are others who can better explain this to you, but I will take a shot.
I'm assuming your building your app with the Witango builders... Under your IfForm action, copy the html from the Results HTML of the current action, then drag in a Search Action. Set that search action to search your IssueDate table. Right click the new search action, and find Results HTML and paste the html you copied previously. Then in the html find the code for your Issue Date input field. Should look something like this: <TD> IssueDate: </TD> <TD> <INPUT NAME="IssueDate" TYPE=TEXT SIZE=40 MAXLENGTH=100 VALUE=""> </TD> and replace it with something like this: <TD> <SELECT NAME="Series" SIZE=1> <OPTION VALUE="">--- Choose One --- <@rows> <OPTION VALUE="<@COLUMN IssueDate.Date'>"><@COLUMN 'IssueDate.Date'> </@rows> </SELECT> </TD> That should give you what you're looking for. Hope this helps. Tom Ferguson -----Original Message----- From: Cecilia Cos [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 1:33 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Dropdown Menu Hello, I am using Tango2000 on WinNT and SQL2000 for db. I have 2 tables in SQL....Log and IssueDate In the Table Log you have the following fields ID Date Login IssueDate Condition In the Table IssueDate you have the following fields ID IssueDate I have created an add new record form using the new record builder for Table Log. I would like to have the field IssueDate in the Table Log be a dropdown menu displaying the IssueDate items in the Table IssueDate and when saved the item goes in to the IssueDate field in the Table Log. Any suggests? Thanks Cecilia C. Cos Data Analyst Newsweek 251 W 57th Street, New York, NY 10019 212-445-4309 [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
