Help

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

600 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jaime
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
Mary_Going2
5 - Automation Enthusiast
5 - Automation Enthusiast

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)
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.
image