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!

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.

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!