I am using Filemaker pro 13 advanced
I have two files: Properties and PropertyValue History. for each property there are several value history records, I have a list layout including both files, the value history file has the year of the corresponding value and the PropertyID, The property file has a field called status which can have a value of active or inactive.
I need to select records of active properties for a specific year. When Y perform a find using the two parameter I do not get the correct number of records, I only get the records for the requested year but whit properties with active and inactive status.
I will appreciate your help, I do not have enough experience with filemaker. Thank you