I have 2 forms (tables). The first one is with product and prices for it. In the second you can select a product from dropdown list (connection from the first form) and  set amount of product. 

So, is it possible to calculate automatically in one field in the second form a price for selected quantity? If I change then price in the first form, the price for selected quantity in the second form will be also changed. It must be not a result of procedure that start on form filling ivent like https://help.zoho.com/portal/en/community/topic/camp-booking-form-calculate-price but common calculation in one field of table like it is in MS Access for example: Amount * Product.Price

Why, if I can put in a field with help of Formula some calculation with data from this form, it's not possible to use in this calculation datas from another form?

Thanks, Alex