Category (pop-up) ->category choices (checkboxes)

[raisputin]

So i have some tables

Table_1, Table_2, Table_3

Table_1 contains ABOS (A Bunch of Stuff) and speicfically a dropdown to choose a Category based on the categories in Table_2 (that was easy enough to do), what I need to know how to do (in dummy terms) is make Table_1 display only relevant options from the choices in Table_3

right now, I am doing the Dropdown by relating Table_2->Category_ID to Table_1->Category_ID and then using a valuelist from Table_2->Category_Name

What I need (trying for explicivity here) is to now display checkboxes from Table_3->Choices

Table_3 contains the fields Choice_ID, Choice and Category_ID

Presently my checkboxes just display all Choices, and I am sure I have missed something here, just not sure what...

Oh Relationships are as follows..

Table_1:Category_ID <-> Table_2:Category_ID

Table_2:Catelgory_ID <-> Table_3:Category_ID

Table_3:Category_ID <-> Table_1:Category_ID