I have two tables that I cannot get connected properly. The first table (Ministry Areas) is used to organize the second table (Groups). The Ministry Area table has 3 fields: MinistryAreaId (one row for every MinistryAreaId), MinistryAreaName, and ParentId. The ParentId is actually a MinistryAreaId. If there is a ParentId, that indicates that this row is actually a sub-level Ministry Area that should be nested under the ParentId/Ministry Area. Does that make sense? I would like to create a filter where I can select any ParentId and it will pull all MinistryAreaIds under that parent.
Can someone help me? Do I need to create a new Parent table or ??
one way is to treat this table as an Area table and then you will need to create another one that introduces the concept of Parent Area, then relate them using Parent Area ID. you let the user select the Parent and the link will allow all sub areas to be selectable
one way is to treat this table as an Area table and then you will need to create another one that introduces the concept of Parent Area, then relate them using Parent Area ID. you let the user select the Parent and the link will allow all sub areas to be selectable
