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 07:32:26 -0800

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 ?
Thanks again.

>-----Original Message-----
>Instead of placing a multi-select listbox on the Customer
>Form, create a new form CustomerSerial whose controlSource
>is tbl-customerSerial with a ComboBox whose RowSource is
>the serial-description, serial-id and whose BoundCoulmn
is 2.
>Then incorporate the CustomerSerial form on the Customer
>Form as a subForm with the customerId as the link between
>the two.
>
>Hope This Helps
>Gerald Stanley MCSD
>>-----Original Message-----
>>Hi.
>>I have 3 tables.
>>1- tbl-customer contains(customer-id, customer-name)
>>2- tbl-serials contains(serial-id, serial-description)
>>3- tbl-customerSerial contains(Customer-id,serial-id)
>>
>>I have created a form that contains the customer info,
and
>>I would like to add a listbox that outputs all the
>>available (predefined values) serial descriptions for
that
>>particular customer. now, a customer can have multiple
>>serial numbers. I would like to store the values chosen
in
>>the listbox in the tbl-customerSerial table.
>>
>>I have searched online for references about this but
>>unfortunatly couldn't find anything .
>>
>>Does anyone know how is this possible?
>>I appreciate all the help.
>>Thank you in advance.
>>
>>.
>>
>.
>

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?
    ... I do see the serial-description values in the combo box ... but a client may have MULTIPLE serial numbers. ... >> serial numbers for each customer. ...
    (microsoft.public.access.forms)
  • Re: GIMUNZIP failure
    ... Many shops have multiple ... You can even order multiple java versions with ServerPac. ... the customer could be supporting multiple ...
    (bit.listserv.ibm-main)
  • Re: Outlook opens all attachments.
    ... > in fax viewer opens the pic from my temporary internet files. ... > we asked the customer to delete the temp folder and open one pic (the ... Maybe they are receiving in a TIF format that permits multiple images ... If one file format can permit multiple pages per file then I would ...
    (microsoft.public.outlook.general)
  • RE: How much do you disclose to customers?
    ... our IP's blocked by an IPS or by an unwitting admin. ... from multiple machines has its advantages, especially when given a class C or larger to split up the time. ... Logs are definitly important, one thing I wish automated scanners ... >> I have a question on customer disclosure. ...
    (Pen-Test)