I have a small GTD database with 3 tables:
- Life Areas
- Projects (with lookup from table Life Areas)
- Actions (with lookup from table Projects)
When an Action is part of a Project, I can figure out via Projects to what Life Area the Action belongs.
Sometimes Actions stand alone: then they don’t belong to any Project. In those cases I do want to be able to link the Action to a Life Area manually, so I added a lookup from table Life Areas to the Actions table as well.
Now here is the question: How do I make sure that when a Project is linked to the Action, the Life Area column is automatically updated by using the Life Area belonging to the used project, and how do I make sure that when there is no Project linked to the Action the user can manually update the Life Area linked to the Action?
In pseudo code, this formula in the Life Area lookup attribute in the Actions table:
— what formula to use here so that manual lookup is possible?—,
Any help is appreciated.