Filemakering me crazy
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.