Record level access for multiple users

[PBainbridge]

I have a query regarding record level access on the web. I have a database in which I would like selected records open to browsing by all users, while the remaining records are viewable only by around 500 users, each with unique IDs and passwords (in the Web Security databases). Any ideas on how this can be achieved?

[Leb i Sol]

selected records open to browsing by all users-

mark those records by use of a field and then use that criteria to fitler them in the serch.

- mark each record (eg. field [VisibleRecord] (1,0) 1- being visible/browsable to all user

OR when a user loggs in

- mark each user record as "guest" or "admin" or "something"

- use the FMP-IF statement when constructing form for a serach based on either "user rights" or "record visibility"

(eg. [FMP-If: UserLevel.eq. admin]....construct the form

FMP-Else .....

or on the results page exclude/include the records based on "RecordVisible" field

All the best!