Pick a clients name and automatically fill clients information
I'm new to filemaker and setting up databases. I work for a non-profit and am trying to set up a simple database to track our volunteers information and hours. What I have set up is a layout with Volunteer Information (basic info - name, address, phone number, organization involved with...) and then a layout with Volunteer time (to enter the hours they work each day).
When I'm entering in the time I would like to be able to pick the volunteers name from my Volunteer Info layout and it automatically fill the organization/church they are a part of (which has already been entered into the Volunteer Info layout). Please let me know if this is possible and how I go about creating this.