How do I add the same child record to selected parents?

[alphacp]

I have a parent table, let's call it Orders, and then I have a child table which is Notes. I would like to use the checkboxes to select a list of Orders and add the same Note to all the selected orders. I just cannot see an easy way of doing this. At some stage I must be allowed to enter the text of the note (INPUT springs to mind) and then add a new record (Note) for each selected Order using that text. 

I thought this had become possible but perhaps not? Any suggestions?

[TeeSee1]

Though not exactly as what you described, something similar can be done at least in the following way..

1. Create a copy_flag (yes/no) both in the Parent and the Notes tables.
2. Create a control table with ID, and a Note text field
3. On the Parent create an action Data: add a new row.... to add a row to the Notes table
   1. ref_to_parent = [_THISROW]
   2. note = Use LOOKUP() to get the Note value from the control table
   3. other fields = Use LOOKUP() to get values from the Notes table that has the flag on
4. On the control table create an action Data: execute an action.. on the Parent, Referenced Rows are the ones with the flag on and Referenced Action being the one in step 3

If you need to deal with multi user scenarios, then you would have to tweak the control table as well as the flags but the idea still holds.

[alphacp]

Thanks. i will give this a go