When you decide to keep individual pieces of data stored in their own records and that data needs to pair up with other data then you need to implement a way for records to be linked together. The process of linking two (or more) records together is simply a matter of using a common key across the set of records. In this lesson we’ll start to link two records together which represent a work session in our Time tracking database.
Link to the file if you don’t want to rebuild from scratch.
https://www.filemakermagazine.com/youtube/scriptology/3/Lesson10