AnsweredAssumed Answered

Problems creating a layout that populates data in related tables

Question asked by ShaneB on Jun 27, 2013
Latest reply on Jun 27, 2013 by philmodjunk

Title

Problems creating a layout that populates data in related tables

Post

     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?

Outcomes