Working with userID of format givenNameLastName but not with....

[raghuprabhu]

I have a table named tblDEFPAC with Given Name, Surname, Phone, Fax, Emailaddress, userID and anID as fields.

This table stores all the details of the employees.

In the second table tblClaims I have Name Of payee, Input by, Input date (default value is date()), anID and userIDString .The userID string contains userID, the machine used to input, and the date and time stamp.

I found this working if the userID is of the format firstNameLastName

It is not working if the userID format is firstName.LastName

All new employees are given userID in the format firstName.LastName

Records by raghuprabhu and timhore are working. Records by jessica.keating is not working. Please help.

You have to input your user details in the table tblDEFPAC first.


Cheers
Raghu