1 of 1 people found this helpful
I would recommend starting off with what is called an "Ancor Bouy" set up so that every layout is based on a primary table occurrence (on the left) and related data comes from the table occurrences on the right. You can capture the doctor who signs in and store his ID so that you can automatically add them to the time entry. If he then selects a facility (and there is only one contract per facility per doctor that is active at any point) then you can find the correct contract for them automatically via the relationship to "billingentries_Contracts~byFacility_Doctor" (see the image below)
This is great. Thank you. This Anchor Buoy concept taught me a ton and solved my problem in the process. Glad I decided to ask for help!