phillsheen
Registered User.
- Local time
- Today, 11:59
- Joined
- Jun 12, 2006
- Messages
- 86
Hi,
Im putting together a membership data base. the data base has an already existing client base which all have membership numbers in the form of first letter of there sir name, last to numbers of the year and a 4 digit number. So for example Joe Bloggs membership number would be B06001 his sister Betty Bloggs would be B06002 and the guy next door John Doh would be D06001.
What I would like to do it automate this system so everytime I make a new record when I input the sir name into the 'lastname' field on the form it checks the last Membership number and makes a new one. I wouild also like it to change the 06 to 07 when the year changes.
Ive done searches for things like this with Dmax etc but i really could use help with the code as I have no idea how to code this type of thing?
Any ideas on this oue would be great!
Cheers
Phill
Im putting together a membership data base. the data base has an already existing client base which all have membership numbers in the form of first letter of there sir name, last to numbers of the year and a 4 digit number. So for example Joe Bloggs membership number would be B06001 his sister Betty Bloggs would be B06002 and the guy next door John Doh would be D06001.
What I would like to do it automate this system so everytime I make a new record when I input the sir name into the 'lastname' field on the form it checks the last Membership number and makes a new one. I wouild also like it to change the 06 to 07 when the year changes.
Ive done searches for things like this with Dmax etc but i really could use help with the code as I have no idea how to code this type of thing?
Any ideas on this oue would be great!
Cheers
Phill
Last edited: