Filtering Data for Display in Layout Mode
I'm trying to display car data in List View in Layout Mode. I only want the data displayed if my Gas Cost > $0.00. Some of the data I want displayed is the date I got gas, odometer, miles per gallon, price per gallon, etc. Right now, I have it working the way I want except it is also displaying dates when I did not get gas. This data is in the body of the layout.
You'll need to perform a find limiting your found set to the desired records. (You don't set up SQL query based record sets for FileMaker layouts like you do in a number of other systems.) This find can be performed by a script automatically when you first enter the layout.
This thread has a number of scripted find examples: Scripted Find Examples