We're trying to create a banking database in FM Pro 7 that includes a check register showing checks, deposits, etc., with a running balance after each transaction (just like in your analog check register) when sorted by date. We're having trouble figuring out how to keep the running balance current, even when checks with previous dates are added later. Does anyone have any samples or ideas?

You can create a summary field which is the total of your transaction amount. (This transaction amount would be one field for both debits and credits, containing positive or negative numbers as needed, and it could certainly be a calculated field if your debits and credits are entered into different fields.) When defining this summary field, you'd check the "running total" option beneath the list of fields available to summarize.

This summary (running) field can be put inside a portal of your transactions or placed on a list view layout and will calculate the running total according to the current sort order in both cases. (very cool).

If something else is giving you trouble with this, feel free to post more details.

John