2 of 2 people found this helpful
"...simple accounting databases..." are far from simple. As a matter of fact their so complicated there are only a few complete solutions available completely using FileMaker.
But to what you are trying to accomplish, you shouldn't connect your relationship in that manner.
Better would be to create a relationship with proper keys and use (if possible) that field in that other table.
For an example, look at the Invoices Starter Solution and see how they use totals and sub totals. More specifically which table they are on and what/how they reference summaries (totals).
1 of 1 people found this helpful
Looks like you should be linking by an account ID field or a Budget category or something like that rather than a subtotal computed from a summary field--which can't be used as a match field anyway.
Thank you Steve, I will play with the Invoices Starter Solution to see what I can learn.