Marc,
Thanks for your response.
As noted in a previous posting on this subject, I have found a usable
workaround with the CONCAT_WS MySQL function. It might not be pretty,
but it does present the data I need, in order to decide which item in
the list I want to select and does it in a readable format.
Thanks for the hint about the "query design window". I will check into
that.
Girvin
Marc Santhoff wrote:
Hi Girvin,
only a quick remark, not thought through and maybe inacceptable in your
case:
Am Dienstag, den 01.07.2008, 13:24 -0700 schrieb Girvin R. Herr:
Quickly, I have a table of suppliers with name, address, city, state,
etc. fields and I am trying to get Base to put more than one field
(column) in a drop-down list box in another table's data entry form.
That way, I can differentiate between suppliers with the same name, but
with different locations (i.e., stores) when I select one from the list.
Can't split up into
- a query collecting the data in one concatenated column
- a listbox showing the data (which would be one column only) in that
query?
Maybe you'll have some more freedom in using SQL when using the query
design window than in the listbox's query field.
HTH,
Marc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
