neilsolaris
Member
- Local time
- Today, 18:40
- Joined
- Apr 19, 2020
- Messages
- 114
Hi,
I have what I hope is a simple question, if I can work out how to phrase it! Basically, I have a table, and two of the fields are foreign keys. What I'd like to do is to create a form, so that I can easily add data to this table. However, in the form I would like to see a drop down list for these fields, but I'd like to view the primary key they relate to in the drop down list.
What would be the easiest way to achieve that?
If need be I can create a sample database, if that makes it easier.
Many thanks for your help.
I have what I hope is a simple question, if I can work out how to phrase it! Basically, I have a table, and two of the fields are foreign keys. What I'd like to do is to create a form, so that I can easily add data to this table. However, in the form I would like to see a drop down list for these fields, but I'd like to view the primary key they relate to in the drop down list.
What would be the easiest way to achieve that?
If need be I can create a sample database, if that makes it easier.
Many thanks for your help.
Last edited: