D
Dan
Hi,
I've tried to make my auto increment field easier but added a prefex
field.
the prefex field needs to be populated automaticly with a default
prefex which it stored in a separate table i.e " E/11/
the logic behind this is so that the user can change the default
prefex of his choosing with ease when ever.
I have created a data entry form and the two field in question are:
prefex:
ProjectQno:
How do i make the form insert the Default prefex in field prefex which
is stored in tbl_prefex?
Secondly how do i implement the DMAX fucntion to insert the next
highest number into the field ProjectQno Automatic? Ending in a
result E/11/ 2526 by showing this on a form as txtResult = txtPrefex
& txtProjectQno
Regards
Dan
I've tried to make my auto increment field easier but added a prefex
field.
the prefex field needs to be populated automaticly with a default
prefex which it stored in a separate table i.e " E/11/
the logic behind this is so that the user can change the default
prefex of his choosing with ease when ever.
I have created a data entry form and the two field in question are:
prefex:
ProjectQno:
How do i make the form insert the Default prefex in field prefex which
is stored in tbl_prefex?
Secondly how do i implement the DMAX fucntion to insert the next
highest number into the field ProjectQno Automatic? Ending in a
result E/11/ 2526 by showing this on a form as txtResult = txtPrefex
& txtProjectQno
Regards
Dan