When I put a App Formula (LOOKUP), the input from column disappears from form view

Hello guys.

I have two tables, one called PRODUCTS and another called SELLS

I need populate a row in the my SELLS table using data from PRODUCTS table, when user type a EAN CODE from a product:

. I have a form type view to add SELLS.
. When user type a EAN CODE into the form, I need loads PRICE, NAME and another infos from PRODUCTS to fill columns from SELLS table.

Eg: The table SELLS have a column called PRICE, and I put a App Formula on that, with theese formula:
LOOKUP([EAN_CODE], โ€œPRODUCTSโ€, โ€œEAN_CODEโ€, โ€œSELL_PRICEโ€)

The problem: When I put theese formula, the field SELLS.[PRICE ] is disappears from my view.

I try use ANY(SELECT()) and same problem occours.

What I doing wrong?

0 1 173
1 REPLY 1

Read this article more closely.

Hint: โ€œ[_THISROW]โ€

Top Labels in this Space