AnsweredAssumed Answered

Linking two fields in a portal

Question asked by Path on Feb 23, 2010
Latest reply on Feb 23, 2010 by philmodjunk


Linking two fields in a portal


Hi there.


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!!!!