Jennifer: I've done something very similar to this. Assign a componentid
to the field where they indicate their approval (like an initials or date
field). Also create a form variable that has the department for the row, like
vDept = Department. Then do something like this on the eep "on row entry"
in the table settings:
IF vuserdept = .vDept THEN
PROPERTY approval ENABLED 'TRUE'
ELSE
PROPERTY approval ENABLED 'FALSE'
ENDIF
Karen
> I have a form with a scrolling region displaying items listed by
> department. I want the users to be able to see all the items but only
> approve/edit
> those items that are listed with their department number. I have the
> security set up so that the application will know who the user is and their
> department – but how do I prevent them from approving or updating items that
> aren’t in their department? Should I use a before update trigger or a rule,
> or would there be a better way to handle this?
>
>
>
>
