Problems creating a layout that populates data in related tables
I am new to FMP and am facing significant issues creating layouts that meet my design needs. Below is the database schema:
I want to first create a layout that will enter can populate a number of fields in each of the database tables, but this is proving very challenging. I have set my first layout up like this:
But when I go to the Browse mode I am unable to select fields that are not on the "Observations" table. The Attriute and Content drop-down lists, which should be pulling information in from their tables, do not function. How do I go about creating a data-entry layout for these items while maintaining the logical data schema I want to use?