Hi All:
I have published an Access Web Database to SharePoint. It has a Main Navigation form and two subforms; one for data entry and the other is a web datasheet (to look like Excel per the end-users' request). In the web datasheet on SharePoint, the lookup fields (20 of them) can only be filtered not sorted when a user right-clicks on the field name. However, if the user opens this web database in Access, goes into the web datasheet form, and right-clicks the same lookup fields, the Sort A to Z, Sort Z to A options are there. Any ideas as to why this is the case? Or how to have these sort options available in the web datasheet form? I posted this in the SharePoint forum as this seemed SharePoint specific rather than the Forms forum.
Thanks.
Merc