Checkbox / List Help needed..

[Brammers]

Hi all, am hoping you can help me, and i've tried to search for a solution already, but finding it hard as i'm not really sure of how to describe what I want to do easily! Hehe

Basically, i've developed a database which utilises it's own 'built in' users and groups section (rather than the FMP Accounts and Groups - for 'client' reasons rather than my own...)

Obviously i've scripted the 'Users' section / layouts so they can only be accessed by members of the Management group. All is working well...

Then I had the idea of creating a checkbox set, detailing the 6 or 7 seperate sections, so that depending on who is 'logged in', a script can cross reference the related 'User' record, and see if the checkbox is ticked for the particular section they are trying to access.

The thing is, if I have a checkbox set with Option A, Option B, Option C etc etc... how can I get a script to check if any one of these selections are checked? I can't really do If (Checkbox)="A" etc, as if A & B are selected, then the result is False.

Is there a way of getting it to see if it CONTAINS a value, rather than if it IS a value??

Thanks in advance for any help...

[comment]

1. You can use:

IsEmpty ( FilterValues ( Checkboxfield ; value ) )

2. I suggest you read this:

http://fmforums.com/forum/showtopic.php?tid/180727/

[Brammers]

Hi, thank you very much for suggesting that - I shall give it a try today and let you know how I get on...

As for the security thing, trust me - I beleive it all! Unfortunately, what the client wants, the client gets, even after me explaining as much as I could about security etc etc...

Luckily it's an in-house solution, so the data shoud still be safe (not that it'd be any good to anyone else...)

[Brammers]

Well, I can't seem to get that method working at all...

I've added temporary text fields to the 'Main' layout (which looks up the User records via a relationship) so I can see what data they are becoming populated with, and it seems to be right, but yet the script still won't work... *******.

[Brammers]

Yay! I've cracked it - just need to test it with multiple records / layouts and users etc, then i'll let you know how I did it...

Thank you for pointing me in the right way though, much appreciated...

[Brammers]

Sorry for delay, but I did promise to let you all know if this worked, and i'm happy to say it does.

I can now restrict access to various parts of the database, by a script that lookups values in 'Checkbox Set', which is held in the Users Section of the database.

Works a treat, and is so easy for my client to give and restrict access without having to edit loads of different things. Especially as they didn't want to use the FMP built in accounts, so i've had to write an entire 'security' part of this database myself!