automatic Check number serial values
I can't seem to find a post relating to this and hoping someone can help -- it seems like it could be a simple script but I am not sure....
I have a table that creates Payment vouchers. There are three banks to choose where the payment will come from. I was hoping that once you choose the bank to fund the payment, it can search for the last voucher that the bank was used and just add 1 to the check number to auto populate the check number field.
Should the script be in the check number field? and which calculations should I be using. Would appreciate any guidance in any form - thanks!!!!