2 step process: 1. SELECT from IssueDate all the values that you want. Place that in an array. 2. In the resultset of your SELECT from Log, use the @CHOICLIST tag to create the dropdown for IssueDate using the array you created in step 1.
That should get you what you're looking for. I don't know your level of expertise, but if a more detailed description is needed, let me know. Kevin. > > From: Cecilia Cos <[EMAIL PROTECTED]> > Date: 2004/03/11 Thu PM 06:33:03 GMT > 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
