Hi all,
I have not been able to find my answer to this, and I have been looking in the forums.
I have a total of 5 tables: Budget, Pillars, Initiatives, Pillar Budgets (Budget and Pillar joined), Initiative Budgets (Budget and Initiatives joined)
Budget contains two Enumlist reference columns. One from Pillars that is “Pillar ID” and a second that is from Initiatives and that is “Initiative ID”. I use these references to create records in the two other tables that join the tables together (Pillar Budgets, and Initiative Budgets). I have all of the actions correct and everything works, however it only lets me populate the Pillar ID column or the Initiative ID column using the reference. Is there a way I can populate both fields so that I can have the actions work simultaneously on both the “Pillar Budgets” joined table and “Initiative Budgets” joined table?
Thanks in advance