AnsweredAssumed Answered

Find records on related tables

Question asked by chihuas on Apr 27, 2016
Latest reply on Apr 28, 2016 by chihuas

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