I have table called people and the rows in this table are parent rows to rows from another table called notes
I have a table of notes that can be added and are related to one or a number of people records
I want to be able to fill in the child record without having to add the related people record via a drop down - I am hoping I can do it as part of the on-submit workflow when writing or updating the child (note) row.
Here is how I am doing it at the moment by manually selcting the key of the parent row to which the notes row relates
(I relaise I can only automatiically add the rowid of the person for whom I am adding the note and to add other parents, to the note row, I would need to do that manually
But i would like to have the row for which the note is originally created have the foreign key populated automatically
To do this I know I will somehow need access to the parent row at the time of submitting the child row - But how to do that?
So the note will initially be assigned to only one user? You can can just add a column component to the form which grabs values from the parent row and passes them through the form automatically.
Thanks for your reply @Jeff_Hager.
You said
“You can can just add a column component to the form which grabs values from the parent row and passes them through the form automatically.”
So I add a column componenet (Text?) to the Note (?) form…Can you pls help me understand what I need to do to have this note column grab values from the parent row?
…at what stage does it grab the row ? And what needs to be done to make that happen - I was uable to see the parent row from the workflow that was possible to do after the submit of teh note row.
Right now I am using a choice field into which t the user has to enter a search term then chooses the correct person name.
If you can please go to the next level of detail - the how would be great
Thanks
Alan
