I am trying to automatically fill fields in a section. See attached picture for reference.
I am making an inbound screen for my pilot cars. This way I can print out a report and see where they all are going to be in a given time period. I currently have a Pilot car data base with all their information entered in. So what I want to do, is in the inbound screen, just choose the pilot car with the drop down and then have all the information automatically filled in. This information being: everything on the left side. Contact name, and phone numbers. Then I'll just input the inbound information myself.
In the Relationship section I do have the Pilot Car database in there and showing it attached. This I know allows me to choose the pilot car I want. Do I also need to connect the particular fields? Or is there some simple calculation that can do this?
I have tried to search the forums, but haven't been able to find anything. I am sure I am just missing something easy.
Thanks in advance for everyones input.
Define the fields to do a lookup from the Pilot Car database based on Unit ID. When you set the Unit ID FileMaker will perform the lookup of the related data and fill it in.