Using information collected in a list box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a list box to connect applications to entities, and the
information is stored in a table, with one record for each entity and an
application list like: 43,29,5,17. This is developed using the For Each
Next loop with itemselected.

Here is my problem is that I don't understand how to use this data in
something that is not another list box. How do I parse this application
field so that I can join with the application table and get the name so I can
print a report of all the applications based on the entity or all the
entities linked to one application.

Do I have to create a new table with a one entity, one application structure
or is there a way to create a temporary dataset that can be used as input to
a query (to be used as input for reports).
 
Are you saying that you have a field that holds more than one fact (i.e.
"43,29,5,17")? If so, consider spending a bit more time looking into
normalization. A well-normalized database (table) would follow the "one
fact, one field" approach.

Why bother? you might ask... Your post is exactly why! It is difficult to
use the strong features and functions that Access offers if the data is not
well-normalized.

You are describing a one-to-many situation.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff

Thanks, I think I knew that, but got enamoured with the code from Allen
Browne about using a list box as a filter. I will rebuild my form and table
structure to utilize a reference table, since I think it will end up being a
many to many construction.

Thanks
 
I use Allen's stuff, too. Perhaps you will want to re-post your issue and
include Allen's name in the subject line. It would make it easier for him
to spot and respond.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top