Josh,
The best solution I've found for this is to create a dummy parent table with a single record and create a relationship with Properties with some new [Related Parent] field. Attach all your Properties to that parent record by grid editing the [Related Parent] field to all read 1 (or whatever the RID ends up being). You could also use an automation for this if you set it up before adding your new record.
You can then create a summary field on the dummy parent table summarizing all your data, then do a look up in your Properties table to pull that aggregated value back down. Not the most straightforward solution, but it works.
I've also solved a similar problem through using javascript on page load, but that functionality is no longer supported.
------------------------------
Oana Toma
------------------------------
