Re: how to store listbox (multiple) values?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: AniG (agarboyan_at_famictech.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 08:55:33 -0800

Hi again,

I have implemented the combo box method as you guys have
described but the values are not stored in the tbl-
customerSerial table.

I do see the serial-description values in the combo box
but when I save the customer info the values are not
stored in the tbl-customerserial table.

What am I missing ????

thanks

>-----Original Message-----
>"AniG" <agarboyan@famictech.com> wrote in message
>news:12fcc01c411b5$3636a480$a101280a@phx.gbl...
>> Yes, but a client may have MULTIPLE serial numbers. And
I
>> want to be able to view those serial numbers in the
>> customer form and be able to select and de-select the
>> serial numbers for each customer.
>>
>> I am having difficulties in inserting the multiple
values
>> into the tbl-customerSerial table.
>>
>> Is there another way to do it ?
>
>Yes, use a relational database as it's intended to be
used. If (1) Client
>can have (many) serial numbers then that is a 1-to-many
relationship that
>should be implemented as TWO tables "related" to each
other on the Client's
>Primary Key field(s).
>
>Then you use a Client main form with an embedded Serial
Number subform
>which would allow you to view/enter/edit as many serial
number entries as
>required per Client without stuffing multiple values into
a single field.
>
>
>--
>I don't check the Email account attached
>to this message. Send instead to...
>RBrandt at Hunter dot com
>
>
>.
>

Relevant Pages

  • Re: Please help with a serious issue
    ... User 1 selects customer 1. ... The credit card table is filtered to that account ... What i basically need to know is how to allow multiple users to use the same ... Customer Shipping - Holds all possible shipping addresses for each client. ...
    (borland.public.delphi.database.ado)
  • Re: how to store listbox (multiple) values?
    ... but a client may have MULTIPLE serial numbers. ... serial numbers for each customer. ... >Instead of placing a multi-select listbox on the Customer ...
    (microsoft.public.access.forms)
  • Re: Table bloat in Linq-SQL
    ... they are created on client site. ... customers with extended properties using Linq-SQL: ... Those scripts are compiled in customer site and can use extended properties. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Odd situation, advice needed on penentration test results
    ... >>I think the reason for the original post is because ... > gone to the client and said something. ... > do is to inform the customer. ... >>intrusion that needs to be analyzed and reported so ...
    (Pen-Test)
  • Re: Table bloat in Linq-SQL
    ... they are created on client site. ... customers with extended properties using Linq-SQL: ... Those scripts are compiled in customer site and can use extended properties. ...
    (microsoft.public.dotnet.languages.csharp)