I need help and i've given up.
I have these 3 fields that my staff put frame numbers into for image sequences. Field 1 is the start frame of the child, field 2 is the End Frame of the child, field 3 is the use frame of that set. My staff sometimes write numbers that are not between those sequences numbers. I wanted to put a calculation that limits the "Use Frame" field to only numbers between the "Start Frame" & the "End Frame" field. Any help would be greatly appreciated. I AM BRAND NEW TO FILEMAKER I PICKED IT UP 2 MONTHS AGO.