access_asp thread: how to create a drop down list of full record but select only one field.
Message #1 by "sohini sengupta" <rumni_sg@h...> on Tue, 18 Jun 2002 05:54:39 +0000
|
|
I have two tables 1. EquipmentMaster -
having fields :
equipmentid
description
2. EquipTransaction
having fields :
transactionid
equipmentid
userid
for entering data in the 2nd table I want to create a drop downlist of the
entire EquipmentMaster record for the field equipmentid and select only
equipmentid from the dropdown list not the description. How will I do it any
ideas?
Thanks in advance.
Sohini.
_________________________________________________________________
Join the world?s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Message #2 by Abdul Sami <abdul_sami_20@y...> on Mon, 17 Jun 2002 23:12:36 -0700 (PDT)
|
|
Try this
Select euipmentid :
<select name=eqid>
<option value=<%=rs.fields("euipmentid")%> >
<%=rs.fields("euipmentid")%>
</option>
</select>
--- sohini sengupta <rumni_sg@h...> wrote:
>
>
>
> I have two tables 1. EquipmentMaster -
> having fields :
> equipmentid
> description
> 2. EquipTransaction
> having fields :
> transactionid
> equipmentid
> userid
> for entering data in the 2nd table I want to create a drop downlist of
> the
> entire EquipmentMaster record for the field equipmentid and select only
> equipmentid from the dropdown list not the description. How will I do it
> any
> ideas?
> Thanks in advance.
> Sohini.
>
> _________________________________________________________________
> Join the world?s largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
>
=====
Abdul Sami
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
Message #3 by "sohini sengupta" <rumni_sg@h...> on Tue, 18 Jun 2002 06:31:05 +0000
|
|
Thanks a lot.
Sohini.
>From: Abdul Sami <abdul_sami_20@y...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Re: how to create a drop down list of full record but
>select only one field.
>Date: Mon, 17 Jun 2002 23:12:36 -0700 (PDT)
>
>Try this
>Select euipmentid :
><select name=eqid>
>
><option value=<%=rs.fields("euipmentid")%> >
><%=rs.fields("euipmentid")%>
> </option>
></select>
>
>
>
>--- sohini sengupta <rumni_sg@h...> wrote:
> >
> >
> >
> > I have two tables 1. EquipmentMaster -
> > having fields :
> > equipmentid
> > description
> > 2. EquipTransaction
> > having fields :
> > transactionid
> > equipmentid
> > userid
> > for entering data in the 2nd table I want to create a drop downlist of
> > the
> > entire EquipmentMaster record for the field equipmentid and select only
> > equipmentid from the dropdown list not the description. How will I do it
> > any
> > ideas?
> > Thanks in advance.
> > Sohini.
> >
> > _________________________________________________________________
> > Join the world?s largest e-mail service with MSN Hotmail.
> > http://www.hotmail.com
> >
> >
>
>
>=====
>Abdul Sami
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! - Official partner of 2002 FIFA World Cup
>http://fifaworldcup.yahoo.com
>
h
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
Message #4 by "Harvey C. Spreckley" <hcs@c...> on Fri, 28 Jun 2002 08:59:14
|
|
Hi Sohini,
I think you've missed the point this code puley fills the list box with
the OPTIONs.
What is required to be known, is what is the itemin the selected or
default SELECT/OPTION box prior to the SUBMIT button being clicked?
Chris Spreckley
hcs@c...
> Try this
Select euipmentid :
<select name=eqid>
<option value=<%=rs.fields("euipmentid")%> >
<%=rs.fields("euipmentid")%>
</option>
</select>
--- sohini sengupta <rumni_sg@h...> wrote:
|
View Cart
