This works one row at a time. Would love to be able to do this to multiple records.
I need to copy several rows that include one column that is a reference the RECORD_ID() for a given table and another cell that has one or more linked records from another table.
The new table has a linked column to the table referenced in the RECORD_ID() above and a column that references the same linked field.
Again, if I create a record and paste into it, it works great. The Record_ID reference connects to the original table we are pulling data from.
Also, if I create 5 rows (as a for instance), I can paste 5 rows I copy from the original table.
Is there any way to copy 40 rows of these two fields and paste them into the other table without first creating the rows in question as blank records? Basically, a paste/append.
I hope this makes sense. Thanks for any insight.