I am doing something I thought would be so simple. I have a Petty Cash database.
The Main Table (Petty Cash) is the record to summarize transactions until a replenishment is needed, generally a month. There are two portals. One is the Petty Cash Detail, each receipt, i.e. date, who and where spent, amount, and GL Code.
The second portal is the cash count, actual cash from the cash box. The total of receipts and cash has to each the total. I have a sum field for each portal the parent record. But for cash count, I only want the total from the ONE most recent record. Is that do-able?