create N-N relation based on multi-check N-N relation

Applications Forms
#1

Greetings All! Thank You for any help and/or assistance you can offer…

I have attached the image of the form to help explain what the problem is.

I have a form that contains three fields 1) product (tee-shirt) 2) color (multi-check select) 3) size (multi-select sizes)

The multi-check field {selColor} array is within the red box.
the multi-select field {selSize} array is within the blue box.

I need to select and display the {selSize} the available sizes based on the multi-check field of color.

I need to be able to build the SELECT selSize field statement based on the selected array of color options.

For example, if the the selected blue, green and red tee-shirts are only available in x-large, the x-large {selSize} should be the only sizes available for the multi-select list.

Thank YOU!

#2

How does look your table structure for it (color, size, available sizes)?

#3

Greetings Reinhard! and Thank You for taking time to a look at this.

I have three tables that provide the data for this form…

#4

For your size select:

SELECT … FROM Table3 WHERE itmID = {field_2} AND cID IN (<cIDs from Table2, separated with comma>)

#5

Thanks for you help Reinhard, I’ll give it a run.

Stu