Jump to content

Prevent all records from being shown when Found Count reaches zero


eljefejb
 Share

This topic is 2614 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

 

I hope this is the right section in which to post this topic.  I am wondering if there is any way to prevent FileMaker from showing all records when the current found set reaches zero records.  For example, when an employee logs in, they are shown the found set of their own work day records for the current month.  I want to allow them to delete records, say, if they accidentally created an extra record that they don't need.  However, if a user deletes all of the records in their found set, then FileMaker shows all the other records in the table.  I have set custom access privileges such that the user cannot see the data from these records (the records show "<No Access>"), but I was hoping there might be some way to get FileMaker to instead just show 0/x records as the found set.  Is this possible, or am I out of luck?

 

Thanks!

Link to comment
Share on other sites

In my quick test, using the Delete All Records command does leave you with all records as you described. However, deleting records one at a time will leave you with a zero found set. So you might consider using a script that loops through your found set and deletes one record at a time. You could use this with a button or a custom menu that replaces the Delete All command.

Link to comment
Share on other sites

Ah!  You're right!  I was using the "Delete All Records" menu item.  I assumed (you know what that makes me!) that the behavior would be the same for deleting records one at a time.  I think I'll add a red 'X' as a delete button, and maybe disable the menu command.

 

Thanks!

Link to comment
Share on other sites

This topic is 2614 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.