Forms and limiting drop downs

  • Thread starter Thread starter John Meyer
  • Start date Start date
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.
 
Back
Top