I want to link 2 records if they are scheduled in the same week, and then create a new record in a table that stores those linked records.
I also want the original 2 records to have the newly created records ID.
My goal is to do the following:
If two records are in the same week, create a record (let's say record A) in table X, then update those two records with record A's record ID#
If anyone could show a visual example on how they would do this that would be highly appreciated as I work better with visual learning.