hi...
i have table name BORROWER(type,model,item_name,borrower_name,borrow _date,due_date,venue,reason)....
i want to make when i click the field item_name,automatically field type and model appear.no need to key- in one by one...
so what the sql formula ?

Can you explain a little more. Is this a Table in html or is this DB? I'm not sure I understand what you're trying to do....

how are your DB and ASP page set up?

that table in DB....

Can you clairfy your question please?

can u give me your full email address?because i want to attach my file including my system to u...