K
Ken Eisman
My user issues a permit that has 2 categories - exempt and non-exempt.
Everything else is identical.
I'm using a yes/no field for exempt/non-exempt and a long field for permit
number.
Permit number has to be unique in each category (exempt/non-exempt) but can
be duplicated between categories.
(i.e. There can be a permit #1 for exempt and another permit #1 for
non-exempt but there cannot be 2 permit #1 that are exempt)
Obviously Autonumber won't work. I think I need to do some sort of SQL
lookup to find the highest existing number in the chosen category and then
add 1
to get the new value for the permit number. (i.e. If category = exempt then
get highest of permit number where category = exempt) I've tried a couple
of things that I thought would work but I've failed miserably.
If anyone has any suggestions, I'd be very grateful. I may be going about
this the wrong way. I wouldn't get my feelings hurt if you told me
that I was way off base.
Thanks
Ken
Everything else is identical.
I'm using a yes/no field for exempt/non-exempt and a long field for permit
number.
Permit number has to be unique in each category (exempt/non-exempt) but can
be duplicated between categories.
(i.e. There can be a permit #1 for exempt and another permit #1 for
non-exempt but there cannot be 2 permit #1 that are exempt)
Obviously Autonumber won't work. I think I need to do some sort of SQL
lookup to find the highest existing number in the chosen category and then
add 1
to get the new value for the permit number. (i.e. If category = exempt then
get highest of permit number where category = exempt) I've tried a couple
of things that I thought would work but I've failed miserably.
If anyone has any suggestions, I'd be very grateful. I may be going about
this the wrong way. I wouldn't get my feelings hurt if you told me
that I was way off base.
Thanks
Ken