So, it sounds like you need some additional structure to accommodate what you're trying to accomplish. Here's how I would approach it:
- Remove the Focus Areas Multi-Select Text and create a separate table.
- Create a new table for Plan Areas, which will be a child to Plans and Focus Areas
- Setup the the Plan so that the user sees a list of all Focus Areas, with a button next to each to add that Focus Area to the current Plan by creating a Plan Area record in the background.
- Setup a relationship between Events and Plan Areas where Plan Areas is the Parent and the drop-down is conditional on the Plan.
The full setup would really require some 1-1 consulting, but is a fairly standard way to structure a process like what you've outlined. Please feel free to reach out to me directly if you need assistance.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 /
http://datablender.io/------------------------------
