Re: multiple fields from a combo box in a single field in related tabl

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Colin Halliday (colinh..at..kothes..com..au)
Date: 07/04/04 

Date: Sun, 4 Jul 2004 12:40:31 +1000

You would only do this for a foreign key to establish the link to the
primary key record, but assuming this is what you are doing:

The drop-down combo box in the table (or form) will only display the first
non-zero width column of the combo-box source. If you want more data to
display in this column you must concatenate the multiple columns into one.
In the source query or Select Statement for the combo box, just concatenate
the required fields. Something like:

Product: [Brand] & " " & [Type]

The word Product is the name given to the derived column (otherwise Access
will call it something like Expr1), the & is the concatenation operator that
strings the text together, and you probably want to leave a space in between
the brand and type so you include a concatenated blank between the other two
fields.

Hope this helps.

Colin

"Hondo64d" <Hondo64d@discussions.microsoft.com> wrote in message
news:05EFFF57-9A11-4B4F-9EE5-8FCC662FC3C4@microsoft.com...
> I am trying to construct a table using other tables as source data. What
I can't figure out is how to get all fields from one record in another table
to display in a single field in the table I am working on. For example. I
have one table for powders. The fields are Brand and Type. In another
table, with a field named powder, I am unable to get the results from the
combo box to display both fields from the table named "Powder". Ie., under
Powder, there is a record with Hodgon as the Brand, and 4350 as the type.
In another table called "Loading Data", there is a field called powder. How
do I get "Hodgon 4350" to display in the "powder" field of the "Loading
Data" table. I have attempted to use the lookup wizzard, and it appears to
access the right information, but it will not display multiple fields into
one in my "Loading Data" Table.
>
> Thanks,
>
> John

Relevant Pages

  • Re: DisplayMember / ValueMember Question
    ... ComboBox can only be bound to a single value and single display column. ... > to concatenate multiple fields from a dataview for use as the value to ... > about a car, such as Make, Model, Year, etc. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: multiple fields from a combo box in a single field in related
    ... John ... > display in this column you must concatenate the multiple columns into one. ... The fields are Brand and Type. ... > Powder, there is a record with Hodgon as the Brand, and 4350 as the type. ...
    (microsoft.public.access.gettingstarted)
  • Re: display contents of preceeding cells consecutively
    ... i HAVE TRIED THE VARIOUS MOTHODS AS WELL AS =CONCATENATE ... (I TRIED TO SAY I FOUND OUT HOW AFTER POSTING BUT WAS TAKING FOREVER TO ... DISPLAY MY MESSAGE HERE ... I would like to display contents of preceeding cells consecutively ...
    (microsoft.public.excel.misc)
  • Excel Formula displays text of formula
    ... two cells =b2&b3 and it displayed the concatenated cells as it should. ... However, on worksheet 2, they tried to concatenate two cells again, but this ... it would not display the result, ... it quit working and went back to displaying the =c5&g5. ...
    (microsoft.public.excel.misc)
  • Re: Number format in a text field
    ... I did was created a Calculation field and just concatenated the four ... The Number field may DISPLAY as 0.123, ... When you concatenate a Number field to some text (with either a Number ... since the format can be different on every Layout. ...
    (comp.databases.filemaker)