I have a summary field that I need to "copy over" to a join table and I can't seem to figure it out.
I have 4 tables...
account_period (1 record to many audits)
Audit (summary of many different policy's to make 1 audit summary)
join_table which joins the audit summary to the policy's
How do I get the summary from the Audit table into the join table?