Lookup multiple values

[Guest]

Using Access XP, can I choose more than one item from a lookup list in one
field i.e. holding Ctrl key and selecting another option doesn't work.

 

[Duane Hookom]

Either wait about a year for Access 12 or create a junction table that
contains one record for each related pair.

 

[Vincent Johns]

Using Access XP, can I choose more than one item from a lookup list in one
field i.e. holding Ctrl key and selecting another option doesn't work.

I'm not sure what you're trying to do. If you are using a Lookup Query
to display values that help you identify the record attached to a
foreign key, you can define your Query to include some or all of two or
more fields from the foreign key's primary Table. For example, the
visible field in your Lookup Query could include an expression like this
in Query Design View:

Name: LastName & ", " & FirstName

In SQL, this expression would look like

... LastName & ", " & FirstName AS Name, ...


-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.