Hey guys,
forgive me if this question is dumb. I have two tables and each with unique fields. I wanted to grab a record from Table2 into Table1. I have been looking up the GetNRecord function and after few hours of banging my head. I still cant get it to work. I am totally new to FM and not sure if i am interpreting it correctly on this function.
edit:
to better elaborate,
I have a price sheets:
(see attached)
and I wanted to create another table, when entered a quantity and number of color, the correct price will show up? Any way to achieve this would be great help.
