I have a table called "Pictures" and in it a container field with a file path. I want to be able to tell if this container field is empty, so I can filter out these records from my portal if they are empty. I don't usually create empty records, but rather than creating a record for every single picture we have, I have just created 200 records and then change the global PropCode field on the fly depending on what property I am on in my Property table. See file path below for the field ImageContainer_cc. If this were a SuperContainer field, I could just use the SCGetInfo function, but this is a Filemaker container field. Thanks.
"imagewin:/S:/Website/Lee/" & PROPERTYINFO::PropCode & PROPERTYINFO::EntityNum & PROPERTYINFO::BldgRCode & "/"
PROPERTYINFO::PropCode & PROPERTYINFO::EntityNum & PROPERTYINFO::BldgRCode & "IMG" & Pictures::RecID & ".jpg"