K
kealaz
Hello,
HOW do I insert a number into a field that is one more than the last number
in a field in a different table? I have a form that I am designing (for
purchase orders). What I need is for it to look at the last record in the
existing purchase order table (tblPOHIST) in the field, P_O_NO, and take that
value, add one and insert that number into the field. i.e., if the last PO #
is 001653, then I need the next one to be 001654.
Thank you in advance for any and all help!
HOW do I insert a number into a field that is one more than the last number
in a field in a different table? I have a form that I am designing (for
purchase orders). What I need is for it to look at the last record in the
existing purchase order table (tblPOHIST) in the field, P_O_NO, and take that
value, add one and insert that number into the field. i.e., if the last PO #
is 001653, then I need the next one to be 001654.
Thank you in advance for any and all help!