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

Outcomes