How is this done? not sure how to describe it, click click....

[ChEEkY ChiNo]

What i need to do is i have an order form for customers within my database, i sellect the company, then what box size they want, then quantity, and what day they want it dellivered on. What i also need to do is to have an extra thing where i can add the dislikes of the customer, so that when they sellect the item they dislike it will add it to a list of the dislikes for that customer. There can be more then 1 dislike.

How would i do this? If more information needed please ask....

 

[Fuga]

It sounds like you should have a separate table for the dislikes linked to the customers ID in the customer table. That way one customer can dislike many things.

Then you can have a subform based on the dislike table.

Fuga.

 

[bradcccs]

As many customers do!

 

[ChEEkY ChiNo]

Yes but how would i get it to sellect a item that they dislike, then it will add it to the dislikes table?

w00t! bradcccs
Another on from Aus

 

[Fuga]

Well the easiest way to do that is to have a list box on the subform, populated with the items, and then have the field in the dislike table as control source.

Fuga.

 

[ChEEkY ChiNo]

Hmmm slowly getting there, just having troubles linking up the dislikes with the customer, so customer 1 dislikes x.

So all the information im got in my order form i am trying to save it to a table called tblOrders, as well as the dislikes saving to a cell in there.

Wait here is some screens hots ive got.

Thats a preview of the form i have

Thats what happens when i add dislikes using the form, doesnt count the user details/order with it.

 

[Fuga]

I would try this:

Tbl 1 (customer):

Customer ID (PK)
Customer name
Customer adress
etc

Tbl 2 (order):

Customer ID (FK)
product
date
etc

Tbl 3 (dislikes):

Customer ID (FK)
disliked product

Main form based on customer table
subform 1 based on order table (linked with customer ID)
subform 2 based on dislike table (linked with customer ID), listbox with control source [disliked product]

Fuga.

 

[ChEEkY ChiNo]

ok im getting somewhere now :d

But the following problems are occuring now.
When i try to make a second record i get this:

And also how would i make it so that Product, day, and quantity are dropdown menus?

Cheers

 

[Fuga]

You probably need to change the datatype of CustomerID in your order table so that duplicates are ok. Maybe you need to change it to integer.

You can use comboboxes in your subform.

Fuga.

 

[ChEEkY ChiNo]

Yeah all i had to do which i found was fixed it was take the Customer ID to NOT be Primary Key

 

[Fuga]

Yes, that´s right.

But you should still have it as a PK in the Customer table.

Glad it worked out.

Fuga.