Now I'm getting confused. What I have wanted to do is always have six values updateable (for the reasons above) from this many to many table. I have chosen drop menus since it is limited to six values chosen (over the other options -- scrollbox, etc). Each of the drop menus should update each of the row values, 1 thru 6, for each user. For each of these Cat_ID values there are 250+ possible values. Each of the W_ID 's are limited to six.
okay, so suppose you did select 6 non-zero rows for some user, could you explaiun again what you want to do with them?you want to create 6 dropdowns with the same 6 entries? just script the same result set 6 times
getting more confused by the minute...