Permanent Field Value Selection with Section Access

[Anonymous]

I have the following section access table:

ACCESS	USERID	PASSWORD	RETAILPHARMACY
ADMIN	CHITEMERERE CHRIS	RUVIMBO320	*
USER	TY6666	BEN55D4	MEDIX
USER	DDDDD-aa	ONESIMOS93AMG	MEDIX
USER	BNNNNNN	CAROLPSP55AMG	PSP
USER	YTRRR	NHAMO65AMGPSP	PSP
USER	UYYYYY	PRIMROSEGWS66	GREENWOOD

When a USERID opens the application and logs in, they need to have the RETAILPHARMACY field value they belong to permanently selected.  For example when USERID TY6666 logs in the application, the field value MEDIX should be permanently selected.  Is this possible in QV and if so how can this be accomplished?

Regards.

[Chanty4u]

hi,

please chk below link

Section Access

Thanks

Suresh

[tresesco]

Document properties->Opening-> Check 'Initial slection based on section access'

[Anonymous]

Thank you Suresh i will have a look at the link

[Anonymous]

Many thanks, if i use the recommended option, i will lose my required initial data reduction based on section access

Regards

[tresesco]

You can alternatively try triggers. OnOpen (application)->Select in field and lock field (if at all required).

[Anonymous]

Thanks Tresesco