Jump to content

Omitting Records


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

Recommended Posts

I'm using Filemaker Server 8.0v4.

Filemaker 8.5 Clients.

I have a Company table that has a InactiveCalc:

Let( LastDate = Max(CompaniesToOrders::OrderDate); Case( Date(Month(LastDate); Day(LastDate); Year(LastDate) + 2) < Get(CurrentDate) or IsEmpty(LastDate); "INACTIVE"))

Basically if a customer hasn't placed an order within 2 years or hasn't placed any orders since we implemented our new database the Companies::InactiveCalc will display INACTIVE.

The problem I have is when I do a Find/Omit on the field Companies::InactiveCalc I still have companies that show up in my found set that are INACTIVE.

I created a sample script called Omit Inactive on my Companies layout. It looks like this.

Go to Layout ["Data-Companies" (Companies)]

Show All Records

Enter Find Mode [Restore] ---> Action Omit Records - Criteria: Companies::InactiveCalc = [iNACTIVE]

Perform Find

Go to Layout ["Print - CustomerMailingLabels" (Companies)]

Print Setup [Restore; No Dialog]

Adjust Window [Resize to Fit]

Enter Preview Mode [Pause]

When I do this I still have Inactive customers in the found set. It doesn't seem to Omit all the Inactive companies.

I have tried do this manually and I get the same results no matter what... Am I just nuts for should this actually "Omit" the records that match INACTIVE in the InactiveCalc field? Or is there something goofy going on since I'm performing a find on a calc field?

Any help would would greatly appreciated!


Link to comment
Share on other sites

This topic is 5781 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

  • Create New...

Important Information

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