AnsweredAssumed Answered

Many To Many Layout Question

Question asked by jkostenbader on Mar 12, 2014
Latest reply on Mar 12, 2014 by philmodjunk

Title

Many To Many Layout Question

Post

     Consider the relationship below. I have two tables Accounts and Features set-up in what I believe is a valid many-to-many relationship joined by a table that contains the primary key from each table. I have a portal set-up based on accounts where I can add "many" features and it works just dandy. I'd like to create a layout based on Features now that shows all the accounts that have any one feature. I thought I could do it via this relationship but its not working as anticipated. I'm guessing I have to create another table instance but I'm unsure how to construct it (still struggling with filemakers use of table instances coming from an Access background). 

     Would appreciate any advice 

     John

Screen_Shot_2014-03-12_at_8.41.42_AM.png

Outcomes