Extra or ad hoc records in a linked table

Topic Labels: Views
350 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast


I have a Base with a table called Controls (about 150 rows) and Assessments(10 rows).  I've got another table called Responses that links to both Controls and Assessments so that for every Assessment Record I get a copy of all 150 Control rows in Responses (so I can answer other columns uniquely for that assessment).  This all works great. 

The problem comes in that I'd now like to use the records in Responses for task management using Kan Ban boards or Ghant charts.  This works wonderfully for the records that are in already in Responses (Linked).  BUT, I'd like to ALSO be able to add some ad hoc Tasks that are not tied to records in controls.  These records could be different for every Assessment. 

I don't see a way that I can do this?  Am I missing something?

1 Reply 1
17 - Neptune
17 - Neptune

Apologies I'm finding it difficult to visualize everything.  Could you share some screenshots of the relevant tables and fields, as well as an example of how you'd like those Task records set up and in which table?