AnsweredAssumed Answered

Update entry based on value List (Based on a table)

Question asked by Tom_Droz on Aug 28, 2016
Latest reply on Aug 28, 2016 by bigtom

Filemaker 14 ADV, Windows


I have a table "Parts"  And a Table "Shop"


I have 9 fields in SHOP for t parts description , where the Drop Down Selections is from "Parts"


When a selection is made I want the other data in "Parts": to come over to that line item in "Shop" (Part#, Price. Cost, etc)


I also need to have the option of entering a Part in Shop that is Not entered in "Parts"


The "Shop" is not a portal to "Parts", nor do I want it to be.


Any thoughts on how to do this?



"Parts" Table



Shop Table