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]
