Hello all, I am a total FM newbie so please keep this in mind.
I have two FM files each one with a table
File_1 contains table "Products". Among others, "Products" contains the following fields needed for a lookup on the second file (see below).
File_2 contains table "POS". Among others, "POS" contains the following fields:
What I would like to do is open "POS", select the title (from a dropdown list that shows titles from "File_1::Products::Title") and then have SKU and Price field auto filled with values from "Products"
How can this be done? Step by step please.