C
cleech
Hello All:
I am working on an access .adp which is basically being used for call
tracking. I have several related combo boxes and list boxes on a
form. As well as free form text boxes. 2 of these list boxes are
multi select. What I'm trying to do is save the selected items in a
table.
(I set up junction tables in SQL to handle this. Not sure if this is
the right approach)
The idea would be that the user could go back to a record and have
the
same items selected in a list box and change them if necessary. As
far as reporting, the (Junction?) table would store individual
records
for each item selected.
I'm familiar with list boxes when I use them for menu controls etc.
Though I usually requery them. So there is never a real need for me
to save the data. I've also looped through ItemsSelected to pass
criteria to a query.
Please let me know if there is a recommended approach for this. Or
if
there is another more efficient way of accomplishing this.
Thanks in advance for any help and let me know if you need more
information.
I am working on an access .adp which is basically being used for call
tracking. I have several related combo boxes and list boxes on a
form. As well as free form text boxes. 2 of these list boxes are
multi select. What I'm trying to do is save the selected items in a
table.
(I set up junction tables in SQL to handle this. Not sure if this is
the right approach)
The idea would be that the user could go back to a record and have
the
same items selected in a list box and change them if necessary. As
far as reporting, the (Junction?) table would store individual
records
for each item selected.
I'm familiar with list boxes when I use them for menu controls etc.
Though I usually requery them. So there is never a real need for me
to save the data. I've also looped through ItemsSelected to pass
criteria to a query.
Please let me know if there is a recommended approach for this. Or
if
there is another more efficient way of accomplishing this.
Thanks in advance for any help and let me know if you need more
information.