How to retrive the Primary Key with Ms Access
Hi
i have created a customerID in the customer table which the is set to PK will be auto-incremented no. I have also set the format with the prefix with "CUS" and follow by 0001.
When i'm using the ASP.NET to return the primary key by using the Select @@ indentity", it only return me the value e.g 1 instead of CUS001.
in addition to that, if use SELECT query statament to query the CUS0001, there is no record return even the CUS001 is exist in the database.
can somebody enlighten me..
regards,
yeekhoon