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.
The correct way to do this depends on what you're actually searching for – e.g. properties that also have a value in a given year, or only entries for a given year.
IIUC, you want to do the latter – then your List layout should be based on the PropertyValue table. Add the related field Property::status to the layout, switch to Find mode, enter the criteria in both fields, and search.
You should get a list of PropertyValue records for only the entered year AND only related to properties with the entered status. If you add the related Property::name field to the layout (and any other necessary related fields), each entry in your list is a complete display of a Property and its value in that year.
Your description seems a bit convoluted to me, but what I think you are describing suggests the simplest solution would be a portal on a Property layout that shows all the related records from the PropertyValue table. If you wish you could filter the portal to show only active records.
Thank you all for your help, I really appreciate the time you take to help others