Hi,
I have a table that called 'Title'. I have made a form with fields from the ' Title' table. In one field i want to put a code. This code must exist the following things: a date, the first two letters from the field Theme, the first letter from the AuthorLastName, the first letter form the AuthorFistname and the TitelID.
All these fields are in the table "Title"
Example:
Date: 02-07-2003
Theme: Thriller
AuthorLastName: King
AuthorFistname: Stephen
TitelID:1
So the code should be like this: 20030702ThKS001
Is it possible? Can i also put underscoll or a point in it.
like this: 20030702_Th_K.S.001
THX IN ADVANCE
Dan
I have a table that called 'Title'. I have made a form with fields from the ' Title' table. In one field i want to put a code. This code must exist the following things: a date, the first two letters from the field Theme, the first letter from the AuthorLastName, the first letter form the AuthorFistname and the TitelID.
All these fields are in the table "Title"
Example:
Date: 02-07-2003
Theme: Thriller
AuthorLastName: King
AuthorFistname: Stephen
TitelID:1
So the code should be like this: 20030702ThKS001
Is it possible? Can i also put underscoll or a point in it.
like this: 20030702_Th_K.S.001
THX IN ADVANCE
Dan