Stew
|
| Posted: 08/29/2002, 7:11 PM |
|
Once a user selects an item, I want only the colours of the item they selected to show up in a list box for their choice. I know my tables are not quite right for this because all I am able to do is list all colours for all products.
I am fairly new to this and need some help.
|
|
|
 |
Nicole
|
| Posted: 08/30/2002, 4:21 AM |
|
Stew,
to list color for selected item only you need to limit the selected items using where clause. I suggest you to use custom sql with item_id parameter included. Do you have any problems with it?
|
|
|
 |
Stew
|
| Posted: 08/30/2002, 8:59 AM |
|
I'm actually practicing designing a product catalogue. I am fairly familiar with the bookstore catalogue that comes with CC. I want to try and expand on that by insdead of books, selling clothing or something with different options for each item.
If a customer selects a particular sweater, how does one set up the access database and the CC to allow them to choose the colour, and size they want from a list box of sizes only available for that individual sweater.
If anyone has some info now that I have better explained myself, I would appreciate it. I am stuck in my tracks right now.
Stew
|
|
|
 |
|