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?
Read this article more closely.
Hint: โ[_THISROW]โ
User | Count |
---|---|
59 | |
25 | |
13 | |
12 | |
6 |