Numeric Value from another table

[admin_nasra]

Hi,

i am working on a service app where i have different tables , i want to fetch a numeric value "Feed Rate" from another table where i have set values of different parameters . i want that "feed rate" value to be populated at the time of entry by the use. for this i have tried select statement , lookup() but may be its numeric it gives error .

Please help

[Steve]

LOOKUP() is a valid approach. Perhaps you're using it incorrectly? Please post a screenshot of both the complete expression and the error message.

[admin_nasra]

Where as Equipment is the column name of my current table and equipment ID is the column of another table named system info and feed rate is the column which is numeric.

[Steve]

Yep, you're using LOOKUP() incorrectly. Please review the help doc.

[admin_nasra]

one more thing please , i am also confused while writing expressions that where would i put it ? will it fits in Show column or in Data Validity Section or in Auto Compute Section .

please refer me some link where these 3 portions are briefly explained .

Thanks in advance