Problem with calculating the total cost of a booking

[RedTrac]

Iv built an expression in my bookings form to try and calulate the toal cost of a booking using the 'price' field on the Rooms table and 'Nights' on the bookings form but its not working.

Can anyone tell me whats wrong here?

=Bookings!Nights*Rooms!Price

Thanks,
RT

 

[Fuga]

I´m not sure about this, but try the syntaxforms!bookings.night
Also, you might want to consider using the me object.

As for the prise field, I´m not sure where you mean the value is? Is it on the bookings form?