Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm looking for a little advice, I have a table kind of like below (but a little more complex)
User | Access |
---|---|
Dean | Invoice Entry |
Mark | Invoice Entry |
Dean | Invoice Approval |
Lee | Invoice Approval |
Mark | Invoice Approval |
Dean | Invoice Payments |
I have a set of rules:
Rule 1 - Anyone with access to Invoice Entry, Invoice Approval and Invoice Payments (e.g. Dean).
Rule 2 - Anyone with Access to Invoice Entry and Invoice Approval (e.g. Dean and Mark).
How would I go about comparing the lines in the table to identify and display which people are in breach of the rules?
(In the script or a chart, I don't mind)
Cheers,
Dean
You may use And-Mode list box. An example is attached.
You may use And-Mode list box. An example is attached.
Thats great, thanks.
Is there a way to only show the items selected?
e.g. when I select Invoice Entry and Invoice payments, it shows Invoice Entry, Invoice Payments and Invoice Approval for Dean.
Thanks,
Dean