I would like to assign personnel listed in a portal to projects by position. I assume a conditional value list will be in play here, but cant seem to show all positions when selecting.Relationships are as follows:
The portal falls in the "all_Projects" table=no problem here. The portal will allow addition of records. Within the 1st field, I would like to select a position from those listed in the "team tables". Once selected, I would like to assign a member, either listed or can be added to the 2nd field within the record.
Ex: members include John, Jane, & Mary. positions could be SE, finance, and PM.
I would like, in the 1st column to select from either drop down or pop up, SE. Then in the second column (same record) assign Mary to that role. I would also like to assign Mike, who is not listed.
Thanks for any help on this.
1 more note, I would like the 2nd field within the record to have a pop-up listing all personnel that had previously been assigned to the selection made in the 1st field (position).