Newbie need help

[Xi Kwok]

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.

[comment]

See if this help:

http://fmforums.com/...overly-complex/

See also:

http://fmforums.com/...ce/#entry292012

http://fmforums.com/...es/#entry285472

---

P.S. Please try to come up with a more descriptive title for your thread next time.