How do I enter (lookup) multiple values in a look-up field (MDB)?

[Guest]

I would like to be able to look up and enter in multiple vaules in a look up
field. Right now if I choose a second value, the first is replaced.
Thank you

 

[Larry Linson]

I would like to be able to look up and enter in multiple vaules in a look
up
field. Right now if I choose a second value, the first is replaced.

Lookup Fields strike again! The Boys and Girls in Redmond should never have
violated Relational Design principles by adding this feature.

Go to Table Design and look at the Details in the box Below the field list
and tell us what they are. Then someone may be able to answer -- this Field
actually refers to a separate, related table which if you use a List Box or
Combo Box as the display control, will be defined in the Row Source.

Larry Linson
Microsoft Access MVP

 

[John Vinson]

I would like to be able to look up and enter in multiple vaules in a look up
field. Right now if I choose a second value, the first is replaced.
Thank you

If you're trying to store multiple values in a single field - YOU
CAN'T, and you shouldn't. That's not how relational databases work!

If you have a one to many relationship, you need to model it as a one
to many relationship - using two tables.

If you could describe your tables, and what it is you're trying to
"enter", someone may be able to help you come up with a properly
relational design.

John W. Vinson[MVP]

 

[Guest]

Thanks
I'm entering biological data regarding primers in a database. One of the
fields is 'references' holding the refernece(s) ID for the source of the
primer. Some of the primers have more then one refernece. I don't wan't to
add multiple reference ID fields but would rather be able to list, for
example, reference 1,3,8. The reference ID are from the reference table and
instead of having to report back the the reference table for the numbers all
the time I have a look up field displaying the primary authors and date and
displaying the ID when one is chosen. I would like to be able to chose
multiple references.

In reagards to the detail bax they are as follows:
display control: combo box
row source type: Table/Query
row source: SELECT articles.[article number], articles.[primary author],
articles.date FROM articles ORDER BY [primary author];
bound column: 1
column count: 3
column heads: no
column widths: 2.54cm;2.54cm;2.54cm
list rows: 50
list width:7/619cm
limi to list: no

thanks very much