F
Felix Oehl
I have a basic database set up for keeping track of Warranty Claims which
uses two tables, one for each of the claims and one for all the parts within
those claims. These are linked on a one to many relationship by the ClaimID
number.
When I create a new record using the form I've made, I want the ClaimID for
the new record to autopopulate with the next claim number in the sequence.
The problem I have is that I need it to be an alphanumeric code. For example
WPC8001, WPC8002 etc.
Can anyone tell me how I can get this to work? I'm new to Access and I'm
afrid my programming experience is pretty minmal too.
Thanks.
uses two tables, one for each of the claims and one for all the parts within
those claims. These are linked on a one to many relationship by the ClaimID
number.
When I create a new record using the form I've made, I want the ClaimID for
the new record to autopopulate with the next claim number in the sequence.
The problem I have is that I need it to be an alphanumeric code. For example
WPC8001, WPC8002 etc.
Can anyone tell me how I can get this to work? I'm new to Access and I'm
afrid my programming experience is pretty minmal too.
Thanks.