This example shows how you can have an incremental check number for multiple accounts. We have one table here to hold an account, in the example we have 3 banks entered. In the second table, we have the transactions of check payments.
The account table calculates what the next check number will be by using a relationship between the account and transaction tables. The account table can see it’s highest related check value and then add a 1 to it.
I added a small script to enter in new check number, via a pop up window. This allows you to use a submission type process for data entry. You can write all types of error checking or event logging off of the submit button. A submission type process makes it easier to react to any special needs your database may have ... in regards to submitted data.
An example file can be downloaded by clicking (here)
© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.