Multiple Select ListBox and concactinate result to Text Field

  • Thread starter Thread starter Tammi Anthony via AccessMonster.com
  • Start date Start date
T

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.
 
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]...
 
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]...
 
Back
Top