Chris Warren
New member
- Local time
- Today, 18:17
- Joined
- Apr 26, 2003
- Messages
- 9
As a novice, this may be a stupid question. If so I apologise.
My problem concerns the order in which data appears in a combo box.
This concerns two tables, Artist’s Names [artistID; name; date of birth;etc] and Addresses [addressID; street; number; area; city]. Because each artist lived at many addresses over their lifetime AND each address was the home of more than one artist, I have created a junction table (called Domicile) with a primary key of both artistID and addressID (together with date and source of the information). The artistID is set to display as a “combo box”. I have set that to display the fields that I want, but unfortunately the order in which the names are displayed in this combo box is by artistID. This makes it almost impossible to find a name, as they were not originally entered into the Artists names table in alphabetical order. I have sorted the Artists names table into alphabetical order but this makes no difference to the order in which the names drop down. Exactly the same effect occurs if I use a form to link artists to addresses.
I will be very grateful for any guidance.
My problem concerns the order in which data appears in a combo box.
This concerns two tables, Artist’s Names [artistID; name; date of birth;etc] and Addresses [addressID; street; number; area; city]. Because each artist lived at many addresses over their lifetime AND each address was the home of more than one artist, I have created a junction table (called Domicile) with a primary key of both artistID and addressID (together with date and source of the information). The artistID is set to display as a “combo box”. I have set that to display the fields that I want, but unfortunately the order in which the names are displayed in this combo box is by artistID. This makes it almost impossible to find a name, as they were not originally entered into the Artists names table in alphabetical order. I have sorted the Artists names table into alphabetical order but this makes no difference to the order in which the names drop down. Exactly the same effect occurs if I use a form to link artists to addresses.
I will be very grateful for any guidance.
