Can you please help me think though how I should design this base? I want to list classes and instructors, but I’m having trouble figuring out how to group by instructor since I’m using the same table for Instructor 1 and Instructor 2
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 ...