Populating fields with a data string?

[ELash]

I'm trying to set up a parent table so that when I’ve got a lookup table populating a field list box I can select multiple items in the table and output a comma delineated string of the selected values into the parent field (or another field). When trying to research this topic, I’ve only been able to find forums which say it can’t be done.

Example:
I’ve got a lookup table consisting of several sets of 3 letter initials of company employees.
The table with the field I’m trying to populate with their initials is a product overview table broken down into rows based upon designated parts of the product creation. For instance the product has parts (A) (B) (C) (D) all the way to (2600 rows). Because each part of the product creation process incorporated different employees I'm looking to create a field in the parent table that will let me interactively select the initials of the various employees (plural) who worked on each of the different parts of the product via a Listbox and store that string in the field as I do data entry via a Form. Basically it is like a multi-select that outputs a string to a table field and each row will have a different string.

I know this can be done, but I’m not sure how. Help please.

 

[PHV]

Have a look here: faq701-4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ELash]

Thanks. That set me in the right direction.