What is the best way to build a recursive search capability into an
FMP10 Script?
For example, you have two tables: People and Characteristics.
People has fields: Name, RecID.
Characteristics has fields: LinkToPeople, CharName, e.g., eye-color,
hair-color, etc., and CharValue, e.g., for eye-color, blue, green,
brown, gray.
I'm looking for a way to do a search in Characteristics that would
find all the People who are red-haired, gray-eyed and left-handed.
Or, in another search, People who are blond-haired, green-eyed and an
IQ over 120.
Can this be done?
Regards,
Chuck
