On Oct 3, 7:00 am, Corey Forman
<CoreyFor...@discussions.microsoft.com> wrote:
> Alright, I might be making this more difficult than it is, but here goes:
> I've currently got a script which will take the number from one field
> (ticket_UserID) and a number which is randomly generated (R = CLng (10000 *
> Rnd)) and takes the first 4 from the ticket_UserID and the last of the R to
> make an 8 digit number. Well now, I want to do the same but not randomly
> generated.
>
> I want to add the UserID to an incremental number so I have a logical
> tracking method for the tickets entered. Below is what I've got.. hope
> someone can !
>
> user_details=split(request("ticket_userid") ,"/")
> rs.Open "select * from tickets where ticket_id=0" , connStr, 2, 2
> rs.AddNew
> rs("ticket_userID") = user_details(0)
> rs("ticket_staff") = "N/A"
> rs("ticket_unread") = 0
> rs("ticket_origin") = "web"
> user_details=split(request("ticket_userID") ,"/")
> Randomize
> R = CLng(10000 * Rnd)
> ticketid=user_details(0) & cstr(R)
> user_name=user_details(1)

Why not have the userid as it's own field, and use an autonumber for
the ticketid field in another table?


table1: (userinfo), userid, firstname, lastname, etc
table2: (ticket info) userid, ticket_userid, ticket_staff, ticket.....

you can join the two tables if need to return the results in a full
query

-J
www.pooradmin.com