Hello. I am opening a form from another form with a SETTABLEVIEW and everything is working just fine. The form opens with the range that I have set and only displays records corrisponding to my range. My question is that anyone can press the “Show All” button and release this range and see all the records. I was under the impression that you could’nt release SETRANGE when you pressed the “Show All” button but it seems to be happening and then anyone can see all the records. Is there any way I can open a form and “Lock down” all the records so that when someone presses “Show All” nothing happens? Thanks for your time! [:)]
Use FILTERGROUP. By placing your filters into a FILTERGROUP other than 0 (zero), the user will not be able to clear these filters. SETTABLEVIEW, by the way, places its filters into FILTERGROUP 2, so pressing “Show all” should not clear them.
Try removing the User Permissions for Table Filter.
Thank you both for your replies! FILTERGROUP was the solution. Many thanks!! [:D]