I use a select statement such as this to add a sensible drop down box to a table control which is a sub form used to show linked info.
SELECT Surname || ' ' || names|| ' ' || Title, id FROM address
My main form is department I need my Sub form field to Contain the id pointing to the linked person. I need it to Show the full name of that person.
It returns two fields,
the first being the concatenation of surname, names and title from my address table.
the second being the id (key) which does the join.
I think you need your database format to be able to cope with concatenation I tend to use SQLite ODBC on WinXP - small and fast!
Dave Legge
Andrew Douglas Pitonyak wrote:
Roman Hausner wrote:
I would like to show the result of a query in a combo-box ... e.g. theDisclaimer: I have not tried this....
first name, last name in a person table, but when the user selects one
entry from the dropdown list, I want the person id from that row to be
entered in the field. Is there a way to do this?
Yes, I think that you can, but I have only tried this in a developer build, which means a pre-version 2.0 release. It worked something like this if I remember correctly...
Create a form named Form1. Insert your first drop-down list box in Form1. Insert Form2 into Form 1. Insert your second list box into Form2.
You can now associate the selected data from Form1 to what is displayed in Form2 I believe. Sorry for being vague, but I have not had time to work with this much lately <drat>.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
