J
jeauxkewl
Need some assistance on this one - I have a form that requires either
a manually entered ID number or to generate one sequentially. I
already have the SQL written to manually increment the ID numbers, but
am drawing a blank as to how to get the control to populate the
field.
For example, a person needs to be entered into the system and they
have an existing university-issued ID number. The form allows manual
entry of any ID. The functionality required is for the user to click a
control (button) that grabs the next available ID from a table (it's
actually a single row/column table that the SQL increments) and
populate the ID field in the form.
Any help is greatly appreciated.
Thanks, Joe
a manually entered ID number or to generate one sequentially. I
already have the SQL written to manually increment the ID numbers, but
am drawing a blank as to how to get the control to populate the
field.
For example, a person needs to be entered into the system and they
have an existing university-issued ID number. The form allows manual
entry of any ID. The functionality required is for the user to click a
control (button) that grabs the next available ID from a table (it's
actually a single row/column table that the SQL increments) and
populate the ID field in the form.
Any help is greatly appreciated.
Thanks, Joe