I am creating a login for emplyees but when they click a button I also need it to grab the next ClientID in a table called tblReferral.
Tables
tblReferral
Forms
frmChoose
Currently I am getting the name from a form called frmChoose it is the same form with the button to be clicked. So I will grab the name from the unbound form and then run a query to grab the max ClientID in tblReferral,Both parts of this the unbound form Name and the Max client ID will then be saved into the table tblReferral.
I hope I did not confuse everyone.