A
Anthony Viscomi
I have a tbl (Dealer_Account_Data); within the tbl there a 2 key number
fields (Prop_ID & Dealer_Acct_Num).
The Prop_ID is always 5 digits and the Dealer_Acct_Num is 6 digits made up
of the 1st 5 digits of the Prop_ID and and incremtal 6 digit for each new
dealer that takes over the property.
What I would like to do is automatically populate the Dealer_Acct_Num field
with the next available/incremantal account #. I can get the Prop_ID from
the from the Prop_ID field that currently resides on the existing form. My
problem is creating the "lookup" that finds the most recent Dealer_Acct_Num
and increments it by 1.
Any thoughts?
Thanks in advance!
Anthony
fields (Prop_ID & Dealer_Acct_Num).
The Prop_ID is always 5 digits and the Dealer_Acct_Num is 6 digits made up
of the 1st 5 digits of the Prop_ID and and incremtal 6 digit for each new
dealer that takes over the property.
What I would like to do is automatically populate the Dealer_Acct_Num field
with the next available/incremantal account #. I can get the Prop_ID from
the from the Prop_ID field that currently resides on the existing form. My
problem is creating the "lookup" that finds the most recent Dealer_Acct_Num
and increments it by 1.
Any thoughts?
Thanks in advance!
Anthony