Help!!! Combo box follow-up..

[vicgirl]

Hi there,
Some people may have read the thread I have posted for combo box. However, the previous solved combo box problem results in another problem. Here is the situation.

I have a combo box called File in Log Entry Form, which saves all the file names to the File field in the Maintable.
This combo box gets the file names from FileList Table, including Drawer, Classification, Sub-Classification(this is the file name) three fields. Since the FileList table includes lots of records, the sub_classification field is automatically filled in this combo box when the Drawer field is enterred. When reviewing the old record, only the Drawer field is displayed in the File combo box. Is there any way to display the sub_classification field instead of Drawer? Any suggestion? Thanks in advance!

In order to explain it more clearly, I have attached the sample .zip file.

The query for the File combo box is :
Select Drawer, classification, sub_classification from FileList

Bound column = 3

 

[sha7jpm]

any use?

not sure if this is exactly the answer you need, but

can you not in the query builder for the combobox move the column "DoR Sub-Classification" to the first column, then put tthe bound column property to number 1...

then the combobox is still linked to the correct field, but displays the subclassification..

think that might give you the answer...

hth

John

 

[vicgirl]

Thanks John. I have suggested it to my supervisor. However, my supervisor insisted that the sub_classification need to be auto-completed after entering Drawer field. Any other way?