Listbox query

[Monty251]

Hi there,

I'm currently working on a system for the company i Work for;

Basically creating a Customer database portal, which the till operative can record some basic customer details (Name and Email) along with the product they are buying.

I have two tables:
Customer Details
-CusID
-Name
-Email
-ProductName

Products
-Name

I have a button on my "Main menu" to add a new customer - they can then add the name, email and select from a Listbox, a product (pulled from products table) or use the search button which i've implemented to be a "wildcard" search.

This all works fine however - How can i make it so i can add multiple items from the Listbox? E.g. if the customer is buying 3 products and not 1?

I've also got a textbox on the "View Customer" form to hold the information from the entered product... How can i use a Listbox here instead?

^^ I can "Edit Customer" also - which brings up all details along with the product search again, i can then add new products to the TEXTBOX and that puts them on a new line, which looks nice. However i was wondering could i have a Listbox then have the ability to Remove an item and Add an item?
So, adding an item to the recorded listbox from a selected item from the database pulled listbox? Aswell as delete from the recorded?

Sorry if it sounds complicated,

Alan.

 

[pr2-eugin]

Monty251, Welcome to AWF..

It is not complicated in Database design, but however, the way you want is might be complicated.. You might need to restructure your DB.. Look up on Normalization.. The Document with this reply should help you understand the basics, then go on to look for the appropriate design example from the already existing Database template models.

Good Luck..