Update existing records with new relationship table

  • 0
  • 1
  • Question
  • Updated 4 weeks ago
  • In Progress
I have created a new table (Projections) with several fields and created a report link and related it to (Jobs) table.  How do I link the existing Jobs to include this report link without doing it job by job?
Photo of Lynne8817

Lynne8817

  • 410 Points 250 badge 2x thumb

Posted 4 weeks ago

  • 0
  • 1
Photo of Casie Masters

Casie Masters

  • 292 Points 250 badge 2x thumb
I have done this before via a table to table relationship and not just a report link.  What are you using as your key field in the Jobs table?  If it is something that is (or can be included) in the Projections table, you can create the relationship.  If you're wanting to add in the fields from the projections table, create that table as the parent and the jobs as the child, then add those fields as lookup fields.