I am trying to create a base for tracking which consultants are assigned to which projects over time. We have a Projects table, a Workers table, and a Project Assignments table linking them. (It’s actually a bit more complicated than that because t...
I think it would work to have a Participant table and a Week Entry table (whatever you want to call them)
Week Entry
FieldTypeParticipantLink to Participant tableRun DistanceNumberRun TimeDurationBike DistanceNumberBike TimeDurationTotal Run/Bike Di...
Thank you very much for your prompt reply. I am a bit disappointed that there’s not some secret setting that will magically do what I want :winking_face: but I’m very grateful for the time you saved me searching for it! I’m probably going to end ...
Thanks for your example! The structure of your Invoices and Line Items makes sense, but I’m not quite sure how to make it work from a form view with a junction table as you describe. What I’d want is something like the following. Three tables: [Pr...