I have a single table with 1000+ records and 10 fields including a Size field and a Colour field.
There are no related tables.
I need two separate scripts please:
1. To find all records with a given size and a given colour. eg size 3 and Red
2. To find all records with a given size but NOT to include up to three colours. eg size 4 but NOT Green, Blue or Yellow.
The end result is to be used for producing labels to attach to products. I can manage the labels part of the script but the Find has me baffled.
I've searched all documentation that I have and looked up numerous websites but cannot find any examples to adapt.
I should add that I'm new to both Filemaker and scripting. (I am familiar with MS Access and used their query system for such tasks as this. NOT SQL).
Many thanks in anticipation.