calc fields in separated structure

[pspafford]

Hey kids,

I've been playing around with a two-file system: one multi-table data file, and one interface file.

Putting all scripts, layouts and value lists in the interface file is very easy; the final piece is the calc fields. While this is also easy enough, a problem arises when you want to show a calc field in a list or portal view.

For example, when viewing a single invoice by way of the interface file, the total can be shown with a Sum ( lineItem::amount ) calc field. However, if you're looking at a list or portal view of invoices, how do you show the total for each invoice?

The answer is probably "The data file will still need some calcs". I was just wondering if anyone had come up with anything brilliant.

Thanks,

Paul

FileMaker Version: Dev 7

Platform: Windows XP