Well..m working on a project using asp as front-end and Sql as back-end.Now the proeblem is that I have to generate Company-id and then the employee-id automatically...So that each time a company details are filled in, they shud be assigned a company-id and then when the employee details wud be filled in, each employee of the company shud again be given an employee-id.

One more problem is there...m passing on company-id from my firstpage to next pages thru querystring method..but its not working...how to do that :(

How do I do this - In design view (inside Enterprise Manager):

> Place a field (I would name it ID) in the company and employee tables
> set the identity of this field to Yes
> make it a primary key

Now every time you insert a record this field will be populated automatically with the next sequential number. NOTE: You do not need to address this field in your insert statement - As mentioned it will populate its self.

I would pass the company ID in a session variable. IMO passing this via a QS is the next best option. Any how to assign it to a QS value for a new user:

> fill in registration form
> submit the form
> insert record
> get the top most ID (this is the record you have just inserted). Lets say your recordset is called RS.

response.redirect("somPageName.asp?cID=" & rs("id") & "")

Now on the page you send them to (somePageName.asp I have used above) do the following:

<%= trim(request.querystring("cID")) %>

Wind is your friend
Matt

I'll again trouble u by my questions MAT :) Well..I wont be discussing this identity problem for sometime...what I want to know is how to assign variable's value(id in my case) to session variable? I wrote this way on my first page--

session("id")=request.form("company_id")

and when m tryin to print the variable on next page by writing-

response.write session("id")


then its not gettin printed on my page... how to use session variable??
I've also made a global.asa file in my root directory ...do i need to do nethin else in order to use session variable?