August 19, 201015 yr I have my database set up so that the user logged in can only see their records which they created. The problem is that when they open the layout to see their records it shows a bunch of records. Is there a way I can add a script to the button that navigates to this layout view that automatically does a find and only shows records created by them instead of showing all records?
August 19, 201015 yr If you've set security privileges for this, when you do a normal Find, the user will only see their own records. Perhaps you already know that. The problem is with the Show All Records command, and also when the database opens and all records are present. If you already have a script that navigates to the layout, just add a Find * (wildcard) in the primary key field, or you could use greater than 0 if it's a number field. The security privileges will handle the filtering.
Create an account or sign in to comment