J
John Meyer
Okay, I have the following table:
STYLES_COLOR_SIZE:
STYLES_ID (fk)
COLOR_ID (fk)
SIZE_ID (fk)
listing all possible styles, colors, and sizes.
I have a second table, lineitem
LINEITEMS;
LI_ID
ORDER_ID (fk)
STYLES_ID (fk)
COLOR_ID (fk)
SIZE_ID (fk)
I need to retrieve all possible values that are already entered in
STYLES_SIZES_COLOR so I can do an insert, but I have to keep the data
seperate. so here's what I need:
I have a form for orders. Each order has one or more line items. When
I insert a lineitem, I need to first off have a drop down list that
displays all possible STYLES_ID in STYLES_SIZES_COLOR. When that
updates, I need a lookup list that displays all possible SIZES in
STYLES_SIZES_COLOR where the STYLE_ID = what has been selected, and when
that's selected, I need COLOR_ID to update in the same way.
STYLES_COLOR_SIZE:
STYLES_ID (fk)
COLOR_ID (fk)
SIZE_ID (fk)
listing all possible styles, colors, and sizes.
I have a second table, lineitem
LINEITEMS;
LI_ID
ORDER_ID (fk)
STYLES_ID (fk)
COLOR_ID (fk)
SIZE_ID (fk)
I need to retrieve all possible values that are already entered in
STYLES_SIZES_COLOR so I can do an insert, but I have to keep the data
seperate. so here's what I need:
I have a form for orders. Each order has one or more line items. When
I insert a lineitem, I need to first off have a drop down list that
displays all possible STYLES_ID in STYLES_SIZES_COLOR. When that
updates, I need a lookup list that displays all possible SIZES in
STYLES_SIZES_COLOR where the STYLE_ID = what has been selected, and when
that's selected, I need COLOR_ID to update in the same way.