Forum Discussion
JordanBeatty1
8 years agoQrew Captain
Sorry, I inherited a system I didn't design about 2 weeks ago and am fairly new to quickbase so I am just working through it's capabilities. As it stands in the Project table, when a Project is created it is assigned a Project Name. In the Task table, in order for a Task to be created, it needs to be related to a Project Name, so Project Name is a foreign key constraint in the Task table. One Project Name can have many Task. All Task have a Task Description field. Currently, when a record is created in the Project table a new record is created in the Task table using actions. When you view the record for an entity in the Project table, there is a report link that shows all associated Task. Currently, you have to leave the Project record and to go modify Task descriptions. So I was trying to use the 'modify' action, so that there can be a field in the Project record that you can use to modify the Task Description of specific task without having to leave the Project record. Currently, when you I actions, since it is a one Project to many Task relationship, it is editing all Task descriptions. So in a Project with 3 task, I can edit all 3 of them simultaneously, but am unable to edit for example just 2 of them. That is why I am wondering if there is a way to target specific records when using the 'modify' action. Sorry, if you are still confused.