I have been building quite a comprehensive app recently using Canvas apps and recently I have moved the main table over to dataverse.
I am now thinking about moving away from having one large table and instead splitting the data into multiple smaller tables.
I have followed a tutorial where you set the primary key and set a lookup from the 'child' table to the 'parent' table but that's about it. In my case the Lookup was the JobID number.
Basically, I want a main table with job lines with columns such as JobID, JobName, Start Date, End Date etc., and then other tables such as Crew with the same JobID and JobName etc., but other columns such as CrewName, Crew Role etc. I may then have another table for Vehicles etc., again referring back to the same JobID and JobName.
What is the best way to join these two tables together and wanting to show them and edit them in a gallery?