I’m trying to create a one-to-many database to track option trading covered calls. The set up is very similar to an invoice. The many records have simple calculations that yield subtotals for each line in a sub-form, all linked to a unique master record, the specific Trade ID.
I’ve been able to set up the sub-total calculations records for each Trade that work correctly, and I’ve been able to create a query that produces a sum of subtotals linked to each trade ID. But I cannot get that sum to work correctly in the form. It will show the correct sum for the first Trade ID, but then will not update when moving to the next master record. It stays on the sum for the first master record.
After a day of trying to find the solution, record refreshing, changing linked fields, etc., I’ve hit the wall.
If anyone has any thoughts, potential solutions, or recommended tutorials to help solve this, I would be most grateful.