disable a field on a query fiorm [message #84485] |
Sun, 21 March 2004 23:01 |
MAQBOOL
Messages: 2 Registered: March 2004
|
Junior Member |
|
|
I have developed many query forms. There are two types of my users. One type is who can see the data of any Personal ID while other type is who can only see his data.
I want to restrict the second type of user to see his data only but currently there are no restrictions in the query forms for this kind of setup.
I do not want to modify the query forms but I want to restrict the second type of users to see the data of his persoanl ID and first type of users to see the data of any personal ID on the same form.
How can I do this.
regards
|
|
|
Re: disable a field on a query fiorm [message #84491 is a reply to message #84485] |
Tue, 23 March 2004 01:07 |
simi
Messages: 23 Registered: August 2002
|
Junior Member |
|
|
I Think you can just add a Default_Where clause in your Pre-Query Trigger
Ex
If user_type=1 then
set_block_property('block',default_where,'person_id = '||personid)
Elsif user_type=2 then
-----
End if
|
|
|