Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to hide or show specific sheets or objects in a QVW, based on a field in the SectionAccess file.
This is my UserAccess table in the SectionAccess file. I plan to set a variable in the QVW, based on the value of field STAFF, but I don't know how to access such field in the QVW. The STAFF field is not part of the data model; it's only on the SA table.
ACCESS | USERID | PASSWORD | NTACCOUNT | CO | SUPVID | STAFF |
USER | * | * | AM\USER1 | ABC | * | Y |
USER | * | * | AM\USER2 | ABC | * | Y |
USER | * | * | AM\USER3 | ABC | * | N |
Thanks.
Thanks. I loaded a copy of the user access table into the data model and got access to the fields. I can now condition the display of specific sheets depending on the field STAFF. Thanks.