So my title may not make much sense, but here is what I have going on.
I have a base that has 2 tables. I have a building table and I have a Tasks table. I have them linked in that some tasks are needed in multiple buildings, so when a task is created it can be assigned to any building that needs that task. However, what I want to be able to do is make a building specific note for each task that only shows for that building
As a hypothetical example: I create the task "add signage" and it can be assigned to building A, Building B, Building C, but not D or E, etc.
In addition on the "tasks" table I have a "notes" field, and a "status" field for each of the tasks, So I can say "label needs to say "welcome in"" or something like that and know if it is "to do" "in progress" or "done".
Here is the part that gets sticky; when I am looking at the buildings page (and it is linked to the tasks page, and have notes show (with a lookup field)) it will show me the notes for any linked task. If I expand the record for building A, and select the "add signage" task, I want to be able to put in a note that says "needed in room 205" that only shows on the "building A" "add signage" task. so that I can open the record for "building B" and leave a note that says "needed in front lobby" that then only shows on the "building B" "add signage" task. but once I close out of adding a note for building A that note shows up on building B as well.
Is there any way to have building specific notes for tasks linked from the tasks table?
Thanks in advance for any help with this situation.
