AnsweredAssumed Answered

Filemakering me crazy

Question asked by DSolomon on Aug 27, 2014
Latest reply on Aug 28, 2014 by philmodjunk

Title

Filemakering me crazy

Post

     Hi,

     I am new to Filemaker and i have watched hours of video and read hundreds of very helpful forum posts but I just cannot seem to get a table relationship to work out.

     I understand the basics of table pk/fk and the one to many etc but rather confused with to's.

     As part of a bigger solution I am trying to create a quoting solution.

     "Companies" have many "Contacts"

     "Companies" have many "Quotes"

     "Quotes" have many "Quote Line Items"

      

     I am wanting two drop down lists at the beginning of a new quote, one to display companies and then the second to display active contacts within the company that was selected above.  Any help achieving this will be greatly appreciated.

      

     Dave

      

Outcomes