Comparing/Checking Lines in a Table

[mccook]

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

[nagaiank · Accepted solution]

You may use And-Mode list box. An example is attached.

[mccook]

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