Another novice question I'm afraid...
I created a "Transactions" form that adds the data to the "transactions" table.
The form has the following fields:
Customer
Product
Price per unit
Number of units
Total Purchase
I created an expression for the "Total Purchase" field to make the result automatic after you type in the Price per unit and number of units. It works great in the form. However, the "total purchase" field of the table is blank. The expression result on the form is not rolling over to the table.
Is there a way to fix this? Again, any help greatly appreciated.