Tables and List Boxes

  • Thread starter Thread starter Douglas @ Helpdesk
  • Start date Start date
D

Douglas @ Helpdesk

I am able to create a Value List on a table and then add it into a form. From
there i can make it a multi-select list. What i have been noticing is that
when i go from record to record what i have selected on the list stays the
same. If i make a change on record 2 to have two items selected when i move
to record 4 they are selected the same. and if i remove one... then they all
reflect it. Is there a way to make this list unique to the record and not the
entire table.

I also notice that when i am in the table view - that i am not able to
select multiple items in that field even tho thru the form and the properties
on that being selected as simple for multi select.

Any recomendations
 
Douglas @ Helpdesk
I am able to create a Value List on a table and then add it into a form. From
there i can make it a multi-select list. What i have been noticing is that
when i go from record to record what i have selected on the list stays the
same. If i make a change on record 2 to have two items selected when i move
to record 4 they are selected the same. and if i remove one... then they all
reflect it. Is there a way to make this list unique to the record and not the
entire table.

I also notice that when i am in the table view - that i am not able to
select multiple items in that field even tho thru the form and the properties
on that being selected as simple for multi select.
Click to expand...


Either upgrade to A2007 (with the diabolical multivalue
field feature) or give it up. A multi-select list box does
not have a value because there can be more than one so it
can not be represented in a field's value.

IMO, what you have started out to do is a disaster waiting
to pounce. Instead of trying to use the evil lookup field
feature, you should be using another table. Since you
should **never** expose a table's sheet view to users, there
is no good reason to use the lookup feature. Instead, you
should use a form to display the data along with a subform
(bound to a separate table) for the multiple items that can
be selected.
 
Back
Top