Multiple Select ListBox and concactinate result to Text Field

[Tammi Anthony via AccessMonster.com]

Ok, here is my problem.

I have a listbox that lists all dependancies from the dependancy table. Each software has several dependancies, so I want this listbox that lists the dependancies to be able to have multi select (I figured that out -- not too difficult), and then after I select 1 or more of the dependancies, I want it to concactinate the results into one text field and store it in a different table.

If I keep it single select, it updates the database just fine, but I need it to work for multiselect. Please help if you can.

 

[Allen Browne]

The multi-select list box is no good for this.

You need a related table, so you can store a record for each of the
dependencies. Then use a subform to enter them (one per row).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Tammi Anthony via AccessMonster.com]

Do you know where I can read about how to do this?

 

[Allen Browne]

For an example, open the Northwind sample database.
Then choose Relationship from the Tools menu.
Access shows you a diagram of how the tables fit together.

One example is the Orders table, linked to the Order Details table. By
putting the related records into the Order Details table, they are able to
add any number of rows to an order. You can then open the Orders form in
design view, and see how the subform lets you add the line items to the
related table.

To read further about this topic, search for Normalization. Here is
Microsoft's introduction:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209534

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Tammi Anthony via AccessMonster.com]

Thank You, I will look into it.