There isn't a way that I know of to do this using the New Record Builder, but you can take what you've created with the builder and expand on it.
by first selecting all the rows in the IssueDate table, and second dynamically generating a drop down list from that resultset.
There are tags to help make this easier like @choicelist
Cecilia Cos wrote:
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_ <http://www.msnbc.com/news/NW-front_Front.asp> 251 W 57^th Street, New York, NY 10019 212-445-4309_ [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
