I was given the task of modifying our databases to take away the actual "Delete" function and give the "ILLUSION" of deleting a record.

I've tried many different ways to do this, but none seem to work.

I have a field called "Found Set" (Global)which will show the current found set and a field called "Total Records" (Global) which will show the total records...

This Logic seems to be right, but it doesn't happent that way in FMP...

Here's what I mean:

Perform Find <-- Pre determined find -->

<-- Omit's records with the value "1" in the "Deleted Field" -->

Set Field [Total Records, "Status(CurrentFoundCount)"]

Modify Last Find

New Record/Request <-- For the User to Enter in what they want to find.

Set Field [Found Set, "Status(CurrentFoundCount)"]

In Theory... This sounds right to me. Not sure about the efficiency...

I thought about using Calculations for this, but I don't know how to capture the "Omited" number of records.

Am I doing this right!?

Can anyone help!?

Thanks!

~Addam~

cTotalRecords = status ( CurrentRecordCount ) - Sum ( Self by iOne to

Thank you SOOO MUCH! I've got it to work perfectly with the scripts...

You are the BEST!!

~Addam~