Linking two fields in a portal
We have created a portal inside a table named competitions. We have a second table called Awards. We need to enter awards inside competitions and for each award to have a category and each category to show a list of subcategories to select from (we need to be able to select more than one subcategory.)
So Competions -> Awards
Category -> Sub Category.
Where do we make the relationship so that it will work that when we enter an award, we can select a category (eg Science or Art) and each category will populate a list of subcategories (eg: Physics, Biology OR Painting, Drawing).
Thank you in advance!!!!