AnsweredAssumed Answered

Help with lookup function (autofill)

Question asked by mkrokos on Dec 18, 2018
Latest reply on Dec 18, 2018 by comment

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).

  1. SKU
  2. Title
  3. Price

File_2 contains table "POS". Among others, "POS" contains the following fields:

  1. SKU
  2. Title
  3. Price

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.

Outcomes