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?