Hi Guys,
  I have to tables in Access - A and B.
  A has info of the company and B has the info of the drivers for that companies.

   I have a asp entry page for driver wherein it has a option tag where I display the company name from table A and when I selected a particular company and insert a driver I need to insert the id related to that company with the driver details into the B table.
Thank you
Andy

Hi,

  AS you said u r inserting driver details. I thought that table A and B are related with companyID. Retrieve company details from the database and fill a select control with value as companyID and text as company_name.
When u enter driver info select the company also from that list. When you submit the form the value property is passed to the server(so companyID but not company_name).

--------
Rajani

hi iam balaji
i want to know the connection to login page in asp if i gave username and password i want to go to next page how to do it and ofcourse iam new to asp pls help me and reply me

Let us know if the username and password that you say are stored in the db for each individual?

Is that you want to know the connection string to connect to the db and pull in data or you are looking for comparing the username and password with that of the db values to let the user into next page?

cheers!

_________________________
- Vijay G
Strive for Perfection