Master/details forms: How to calculate a field in the master according to fields in the details

preview_player
Показать описание
In this video, we discuss how to calculate a field in a master form according to fields in the details form.

DaDaBIK is a low-code/no-code platform for Web database application Development.

Credits:
Music: "Future City Funk" by bad Snacks
Рекомендации по теме
Комментарии
Автор

WARNING: for some reason the UPDATE SQL in the video query misses the WHERE clause on the main statement, you have to add it otherwise you will update total_amount_invoice for ALL your invoices.

DaDaBIK
Автор

hi is that ok if you can tell me how to display other data from other table in the form like you did for the invoice items.

abbasjamibollah
Автор

Hi Eugenio, how would I add a totals field to the form without it being in the Invoice table and then update it like this?

uruthrak