I have a database that has several tables within it. Each table contains
different ellements for an assembly of different components. I am trying to
creat a field or report that will take the selected items (1 Each from each
table) and place just the text from that tables field into a text box. When
the form is used to create a new component, you simply go down the list of
combo boxes and select all the ellements of your assembly. After you have
selected all the components and thier respective sizes, I want this to take
all this information and create on text box containing all this pre-selected
information. This will allow me to end up with a constant description for
all new components. I can't seem to figure out how to take the individual
selections from each talbe and place them into one new field.

I'm not sure this is a good idea. What if after you have created this
description, somone changes the components, then you have a misleading
description and you need to update it.
Why not just create the description on-the-fly whenever it is needed?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"David" wrote:

> I have a database that has several tables within it. Each table contains
> different ellements for an assembly of different components. I am trying to
> creat a field or report that will take the selected items (1 Each from each
> table) and place just the text from that tables field into a text box. When
> the form is used to create a new component, you simply go down the list of
> combo boxes and select all the ellements of your assembly. After you have
> selected all the components and thier respective sizes, I want this to take
> all this information and create on text box containing all this pre-selected
> information. This will allow me to end up with a constant description for
> all new components. I can't seem to figure out how to take the individual
> selections from each talbe and place them into one new field.