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
Tables:
Instruc...
ScottWorld: Thank you for this suggestion, but allow me to clarify: these are not two sections of the same class. The same class has two instructors who teach together. Two instructors, one class.
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 ...
