Search the Community
Showing results for tags 'multi-criteria'.
I am running FileMaker 14 on a Win 10 machine. I have a set of records that each have a field with a starting number and a field with an ending number. I have to perform a find that locates the record where the find criteria is greater than or equal to the starting number AND less than or equal to the ending number. I need to write a script that will just let the user enter the find criteria in a edit box and then go to the record. This will theoretically be only one record that would match from the dataset. Can anyone point me in the right direction with this? Thanks RDW
Using a multi-criteria relationship I want to accomplish a conditional value list. pk_ID (not equal) fk_ID cTotalAmount (greater) gZero but as cTotalAmount is a calculation field it doesn’t work properly. I’ve tried with a calculated numeric field (=cTotalAmount), but this doesn’t updates automatically as a calculated field. Any suggestion?
I am trying to chart and analyze sale data. In particular, "Most popular product(from a specific product category) this quarter/month/year/etc" and things of that nature. In this database there are several tables: I will try to explain how they are linked Sales Order -Sales Order Line Item --Product Product Category -Product --Sales Order Line Item For example, I want to see the most popular product during a certain fiscal quarter do do so, I need to filter the line items by the following criteria and then have a calculation of the sum of found line items grouped by prod