This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
