Composite primary key to other table as foreign key?

"Pat Hartman" wrote:

Although you can use a multi-field unique identifier with a combo, it
requires coding. The simpler solution is to change the current composite PK
to a unique index and add an autonumber to serve as the PK. That will fix
your problem with the combo. But it does create a visual issue since the
combo will show only a single field once it is closed. One solution is to
concatenate the fields you want to show in the closed combo so that they are
all mushed together as a single field for display purposes.

Where is the best place to concatenate the fields for the closed combo
display? I could create a query that joins my two fields with a space in
between - and then they wouldn't be so mushed.

On Wed, 20 May 2009 02:52:03 -0700, Shabra Dowson Shabra
wrote:

Although you can use a multi-field unique identifier with a combo, it
requires coding. The simpler solution is to change the current composite PK
to a unique index and add an autonumber to serve as the PK. That will fix
your problem with the combo. But it does create a visual issue since the
combo will show only a single field once it is closed. One solution is to
concatenate the fields you want to show in the closed combo so that they are
all mushed together as a single field for display purposes.

Where is the best place to concatenate the fields for the closed combo
display? I could create a query that joins my two fields with a space in
between - and then they wouldn't be so mushed.

The query is the right place. And when I say query, it can be either
a saved query or a query string right in the row source property. The
saved query is more reusable, if this combobox appears on other forms
too.

Just concatenate the fields that you want to display in the closed
combobox, and include formatting characters too, if you like. (spaces,
hyphens, parentheses, etc.)

Armen Stein
Microsoft Access MVP
www.JStreetTech.com