Tables - Lookup values

[Amanda Knott]

Is there any way to have a look up (using lookup wizard) that you can
select more than one option. For example, I want to be able to chose
all applicable branches whether it be one branch or all 5.
TIA
Amanda

 

[Larry Linson]

Is there any way to have a look up (using lookup wizard) that you can
select more than one option. For example, I want to be able to chose
all applicable branches whether it be one branch or all 5.

Sooner or later, Fields defined with the Lookup Wizard are going to cause
you much more trouble than they ever saved you. Your Table design would need
to accomodate multiple options, and the best way to do that is with a
related Table. If you put multiple Fields for the same kind of data in your
record, or if you put multiple values in the same Field, you will soon
regret that choice.

Larry Linson
Microsoft Access MVP

 

[John Vinson]

Is there any way to have a look up (using lookup wizard) that you can
select more than one option. For example, I want to be able to chose
all applicable branches whether it be one branch or all 5.
TIA
Amanda

No, there is not.

Table lookup fields are of VERY limited utility, and most developers
advise not using them AT ALL. See

http://www.mvps.org/access/lookupfields.htm

for a critique.

However, it's easy to do this on a Form (which is a much better way to
enter and edit data than a table datasheet in any case). To have a
combo box which lets you include "All" as an option, see

http://www.mvps.org/access/forms/frm0043.htm

If you prefer, you can use a multiselect Listbox, and choose one, two
or more entries:

http://www.mvps.org/access/forms/frm0007.htm

John W. Vinson[MVP]