I have an “order fulfillment” database in which I created “Custom field” “total_import” which
I have to calculate from the “orders” database with the fields “prz” * “qnt”.
How can I do?
thank
By “database” did you actually mean “table”?
yes
You may create a view to join the tables and calculate the total accordingly.
I need to calculate a total field in the ev_ord table by calculating the value of the field “qnt” and “prz” (qnt * prz) which are in the ord table.
it’s possible ?
arbei wrote:
You may create a view to join the tables and calculate the total accordingly.
Create a view to join the ev_ord and the ord table first.
I don’t explain well …
I need to report a total on the “tot” field of the ev_ord table which is
taken from the “orders” table from the “prz * qnt” fields … is it possible ???
You may create a view as suggested or you may use Custom Field, see the topic Custom Field in the help file.