Hello, I was wondering if it was possible within Sesame to set multiple key fields for your relational databases within your main parent database? For example: I have a main database which is "Customers" then as a subform I have "Jobs". Within "Jobs" I have "Phases". Within "Phases" I have "Estimates", "Services", and "Payments". When I select a "Phase" subrecord. I would like to use the two key fields of "Job_ID" and "Phase_ID" as a composite key field. That will allow me to only see subrecords matching those two key fields. Anyone know if this is currently possible? Or should I just simplify?

Will that work to display only the subrecords I want to display? For example. For Customer 1, Job has 3 records and, Phase has 6 records. When I select Job 2, I only want to display Phase 2-3, as those correspond to that actual job.