limiting data set to specific groups

[icefield]

hi folks,

here's my story. we are trying to set up a master db which contains all the information from 12 different regional centers. i would like to set up the db so that if a center connects to the master db, the center will only be able to access it's own data. is this possible? thanks in advance for any sage wisdom and advice!

also, would it be possible to "filter" the layouts as well?

regards,

ez

[marija]

Hmm. I wonder if you could do a "Find" in a script that runs when the user opens the database. You can use the groups/users to set up passwords. When a user logs in under a certain group, you can use the Status(CurrentGroups) function in a script to determine the user, then run a find based on that.

You can restrict layouts using the built-in security functions.

You would just have to make it so the user can't activate the "Show All Records" command, which I don't know how to do offhand, but wouldn't say it can't be done!

Hope this helps.