Background:I work for a training provider, offering courses online and in-person. We work with ~50 (and counting...) independent instructors to deliver our live Zoom and field sessions.When scheduling our course deliveries, our Program Managers reach...
Hey Doug, It's not possible to use the 'Link to another record' field type for your primary field. It sounds like you want the primary record to be the same on both tables, which is a clue that hosting all the information in one Table would work. App...
Yeah, I'm thinking a table holding records for each day of the year, with cells linked to instructor and deliveries tables will be the best way forward on this one. Potential to get a little messy when we have deliveries running in parallel but can u...
Thanks @ScottWorld! I understand the many to many approach, but am struggling to apply this to our need to allocate an instructor different parts of a delivery. I have 3x tables in my base; one for our list of products (courses), one for our list of ...
