AnsweredAssumed Answered

Creating a simple 1 to many layout view......

Question asked by jon@thanspence.com on Aug 3, 2015
Latest reply on Aug 3, 2015 by philmodjunk

Title

Creating a simple 1 to many layout view......

Post

I am new to Filemaker (I understand relational databases and have used Microsoft Access 2003 many years ago) I have created 2 tables... Expense Period and Expenditure see below....

And have set the relationships as follows:

I have then tried to create a layout, so that I had a Period view and a portal to display the related expenditure details. However, when I press Add new record it creates a new period record rather than an expenditure record. How do I stay on the same period record and create multiple expenditure records for the period record. 

 

Outcomes