Hi,

I have created a solution whereby it involved a max limit a person can see.

This is the situation. User A is having a max viewing value of 10000. So all the records within the range of 0 to 10000 can be displayed out.

Let say I key in a new record where by the value is 20000. How do I make the system where by I can only view the records of 0 to 10000 and the records which exceed the limit that created by my ID ?

Thanks.

2 ways of doing this:

- if your solution is completely scripted (all navigation) then you produce the proper record set as the user goes into a layout. You might want to use SecureFM to take away all menus in this scenario

- or, in the user's privilege set, for the Records: set it to "custom privileges". Set the viewing bit to "limited" and enter a calc that dictate what records the user can view.

Thanks it works. !