Please advise if this is posted to the wrong sub-forum.
Dealing with two of my linked tables, which apart from this, are working well.
The first [Products], contains a field 'Cost'.
The second [Transactions] contains the fields 'Sold' and 'Net'.
My dilemma is trying to get the second table to multiply the value contained in [Products].Cost by the value in [Transactions].Sold and paste the answer automatically into [Transactions].Net.
The goal being to enter data into a Transaction table/form and the moment the 'Sold' field (quantity sold) is filled, the calculation to update the 'Net' (how much made today) is automatically made and pasted.
I've been down all kinds roads looking for the method, but not found it yet. I'm sure one you bright folks can point me in the right direction.
Many thanks