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?