I'm in between a rock and a hard place on this one...
I'm building an ADP project w/SQL server back end. I have a main form with several subforms. I would like to have the data in my subforms sorted in a certain order, but the field I want to sort on is a field that is joined with a lookup table to display a text value instead of numeric ID. This field is a combobox control on my subform. I know the best way to do this is to base the subform off of a SQL View in which I join this field to the lookup table for sorting purposes. This works fine except I am running into the problem described in the following Microsoft KB Article...
Unfortunately, the workarounds in this article don't work for me, so the only solution is to base my subform off of a SQL Table instead of a View.
I'm wondering if anyone knows how to sort form data when the form is based off of a SQL table? The OrderBy property isn't working worth a darn. What's worse, I need to sort the form not on the ID field, but the lookup text value based on that ID. I think I might just be out of luck.
I'm building an ADP project w/SQL server back end. I have a main form with several subforms. I would like to have the data in my subforms sorted in a certain order, but the field I want to sort on is a field that is joined with a lookup table to display a text value instead of numeric ID. This field is a combobox control on my subform. I know the best way to do this is to base the subform off of a SQL View in which I join this field to the lookup table for sorting purposes. This works fine except I am running into the problem described in the following Microsoft KB Article...
Unfortunately, the workarounds in this article don't work for me, so the only solution is to base my subform off of a SQL Table instead of a View.
I'm wondering if anyone knows how to sort form data when the form is based off of a SQL table? The OrderBy property isn't working worth a darn. What's worse, I need to sort the form not on the ID field, but the lookup text value based on that ID. I think I might just be out of luck.