I have a database that was made for just one user, but know I'm looking into making it for 5-8 users that can't records form each other.

I have learned to make accounts and privilege set that use limited view for table records by calculation of "Account = Get (AccountName)" where Account is the name of the owner of the record.

But if user1 logs in he sees a lot of records where is in every field.

How is the best way to hide these records?

I have layouts that use table views and form views and they are accessed by buttons, so I think I could make a script that loops through every record and omit records that the users doesn't own. Is there another way?

Thanks,

Halli

Performing ANY find, even a bogus one, will automatically omit these records from the found set. You could include this in your startup script and/or in your navigation scripts. Make sure your users cannot invoke Show All Records or Show Omitted Only commands.

Thank you. That's a good trick, just what I needed.

I only searched for * and got all records for the user.