natemclain Posted December 8, 2006 Share Posted December 8, 2006 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! Nate Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6321 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 accountSign in
Already have an account? Sign in here.
Sign In Now