I have table called Programs that creates new programs. I added a button inside each row that adds tasks to another task table.
When I create a new row in the task table i do it by using a button inside the program table that adds a row to the task table. It populate the Program Name which is a linked column inside of my task table.
It works but I’d buggy and has a conflict. It says the problem it is being updated by both the Program Table when I create a new program as well as by task table when I create the task.
The name always populates but the linked fields don’t always update unless it was entered by the Program table originally ( not via a task).
Is their a logic problem problem here? Or is it a format problem. I mention format because if I update it with the task table it inherits formatting from the original Program Task Name (support table) whereas the the related program name Column linked in my task table doesn’t inherit the value.
Grateful if others have solved it.