Unanswered: Datasheet with one combobox dependent on another combobox
I have a very simple setup:
Table Size: rows with different sizes
Table Type: rows with different types
Table Type_Size: rows showing which Sizes/Types combinations are permitted.
Thus Type 1 might be available in Size S and M, but Type 2 might only be available in Size L.
I have set up a form (i.e. for purchases) that allows a user to choose a Type from a combobox (easy query to fill the combobox). There is also a Size combobox with a simple query that adds an additional WHERE clause to only show Sizes for the specific Type selected in combobox #1 (based on the allowed combinations listed in Type_Size).
I requery combobox #2 based on two events: change in combobox #1, or change in current record. As a form this works beautifully! I can only choose Sizes appropriate to each Type. Exactly what I want.
Now I want to convert said form to a Datasheet. The query for the combobox #2 is the same across all rows of the Datasheet. In fact the results are pretty funny. If I have say 10 rows already displayed in the Datasheet and I select a row that has an item of Type 1, then all the rows with items Type 1 will list the size that was selected for that entry (since the query becomes valid). All the other rows will not show a size -- unless that size happens to also be available for Type 1.
Any suggestions on how to make a Datasheet where each row displays the data it is supposed to?