I am practicing with this online tech support request form. The user can submit a request which is inserted into two different tables. That works fine and it keeps the tables relationship. <BR><BR>My main problem is trying to increment the 'IssueID' field. It's datatype is a string with each issue starting with 'iss' and some number like (iss-100). When a new issue is inserted into the database I would like it to increment by 1 from the last record like(ex: iss-101). Keep in mind I would like to keep the most efficient performance possible. I would appreciate any assistance, thanks.