Ok, so stick with me people as I am new to FileMaker and scripting so Novice is a word that is too experienced for me! We have a property company and people move in and out of our properties frequently. In my property list layout I want to demonstrate which properties are currently empty, so I have added a simple script that looks at the at the resident details, as follows:
If(IsEmpty (Residents::Leave Date); Residents::Booking Name;"")
So essentially if there is no leave date then add the persons name, however, this only looks at the first record for resident connected to that property address and if ere is a leave date it leaves the field blank. What do I need to add to the script to check for any other residents associated with that property.