Is it possible to have part of the primary key of one table set by
making a selection from a list box which displays values from another
table.
I have two tables Patient and referral. The primary key for patient is
Hospital number.
The primary key for referral would be Hospital number and the date of
the referral. I want Hospital number in referral to be a foreign
key-connected to Patient thus ensuring that any hospital number in
referral must be in Patient.
I would also like the nurses entering the information to be able to
choose the value of Hospital number of referral from a list box that
listed the values of hospital number in Patient.
Is this possible in access. It doesn't seem to like it.
Thanks
Peter