default
|
| Posted: 03/05/2003, 4:55 PM |
|
I have a listbox populated with Supplier names, I would like to have a
hidden field in the form ( supplierID) that will change based on the
name chosen. that will then insert this number into the database along
with the other input.
using asp with access 2k: orders table with supplierID and Suppliers
table with SupplierID have a relationship.
thx for any insight.
|
|
|
 |
DonB
|
| Posted: 03/06/2003, 8:53 AM |
|
But... If you specify the listbox as bound to the supplierID column, and
that the supplierName is to be displayed, you don't need to use a hidden
field.
DonB
"default" <martin(remove)@ondeck.com> wrote in message
news:hr6d6vgsce6ipokn4nugvje85pqee5v04d@4ax.com...
> I have a listbox populated with Supplier names, I would like to have a
> hidden field in the form ( supplierID) that will change based on the
> name chosen. that will then insert this number into the database along
> with the other input.
> using asp with access 2k: orders table with supplierID and Suppliers
> table with SupplierID have a relationship.
>
> thx for any insight.
|
|
|
|
Martin
|
| Posted: 03/06/2003, 11:13 AM |
|
that's too easy, and now that I see it ...so obvious
thanks!
On Thu, 6 Mar 2003 11:53:57 -0500, "DonB" <dbweb2@premiersi.com>
wrote:
>But... If you specify the listbox as bound to the supplierID column, and
>that the supplierName is to be displayed, you don't need to use a hidden
>field.
>
>DonB
>
>
>"default" <martin(remove)@ondeck.com> wrote in message
>news:hr6d6vgsce6ipokn4nugvje85pqee5v04d@4ax.com...
>> I have a listbox populated with Supplier names, I would like to have a
>> hidden field in the form ( supplierID) that will change based on the
>> name chosen. that will then insert this number into the database along
>> with the other input.
>> using asp with access 2k: orders table with supplierID and Suppliers
>> table with SupplierID have a relationship.
>>
>> thx for any insight.
>
|
|
|
|
Martin
|
| Posted: 03/10/2003, 12:08 PM |
|
post didn't work last fri. in any case what seemed obvious and simple
is not the case. if I bind supplierID to the lisbox (listing suppliers
names) then a number gets inserted into the orders database.
I have tried every combination and am ready to give up on using the
IDE for this seemingly simple task
On Thu, 6 Mar 2003 11:53:57 -0500, "DonB" <dbweb2@premiersi.com>
wrote:
>But... If you specify the listbox as bound to the supplierID column, and
>that the supplierName is to be displayed, you don't need to use a hidden
>field.
>
>DonB
>
>
>"default" <martin(remove)@ondeck.com> wrote in message
>news:hr6d6vgsce6ipokn4nugvje85pqee5v04d@4ax.com...
>> I have a listbox populated with Supplier names, I would like to have a
>> hidden field in the form ( supplierID) that will change based on the
>> name chosen. that will then insert this number into the database along
>> with the other input.
>> using asp with access 2k: orders table with supplierID and Suppliers
>> table with SupplierID have a relationship.
>>
>> thx for any insight.
>
|
|
|
|
|
