>>I have a reference table which is a list of names. I need to create a combo box which use this table as a reference. However, there is a special requirement in the order of the list showing in the combo box. 3 of the names should always be shown on the top of the list while the others should be shown according to the alphabetical order. Since the table will be updated once in a while, placing the record order permanently is not viable. Can anyone help me in this issue? Thanks.
>>
>>Chu
>
>Add another field to your reference table. Put something like '1', '2' or '3' in the new field for those records that have to be listed first. For all other records, put the actual data of the sort field in this new field. Create an index tag on the new field and use this order. Make sure in any "AddItem" routine you also populate this field.
How about if I have new record? By doing so, I will need to recreate the order again, won't I?
Chu
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement