Yeah, yeah yeah. I know the answer might be simple but im new to this and I still can't figure it out.
Any way here it goes.
I have at the moment two tables. Products and product colors. joined by the product unique key. one product has multiple colors. the problem is i need that when i choose one product on a form all the colors with the same product key must be pulled up and showed to choose. This is going to happen in a subform. This subform is shown as a table. Any ideas how to set this up.