I am creating some custom forms for our Marketing team. We are planning on having Programs = Campaigns, theProgram will focus on a Brand and the task level work might involve specifc Brand related promotion. They asked for a field that would indicate the product. It would be helpful to isolate the list based on the Brand selected at the Program level, instead of re-selecting the brand on the task form to make the display logic work. So the example would be: If "Brand A" is selected at the Program level, corresponding "Product list A" is diplayed at the Task level. If "Brand B" then "Product list B" is displayed at the Task level.
Seems like maybe there's way with calculated fields...???
thanks