Auto-link all rows to new records in a different table

I have 2 tables:

  • Customers
  • Workouts

When I create a new workout I want to auto-link it to every customer in the customers table. Is there a way to do this?

I found a ‘hack’ of sorts on the forum - grouping workouts by linked customers and then adding rows from below the group that contains all customers. But the problem with this is that I need it to automatically include any additional customers when they get added to the customer table.

Any suggestions?

Here’s an idea:
Create three tables:

Customers
Workouts
LINKER

Linker has two fields:
LinkName (Single Line Text)
Workouts (Link to the workouts table. Allow linking to multiple)

This table gets one record only. Name it “LINKALL”. Every time you add a new workout, add it to this record:
image

In Customers, add two new fields:
Linker (Link to the Linker table)
All Workouts (Lookup field: Look up the workouts from Linker)

Each customer’s Linker Field should be linked to that one record in Linker. It will then pull in all of the workouts.

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.