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

Topic Labels: Base design
1783 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

1 Reply 1
5 - Automation Enthusiast
5 - Automation Enthusiast

Here’s an idea:
Create three tables:


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:

In Customers, add two new fields:
Linker (Link to the Linker table)
All Workouts (Lookup field: Look up the workouts from Linker)
Screen Shot 07-21-20 at 05.41 PM

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