A simple problem or not?
The first of two related tables is a simple expense report allowing the user to select a category from a third table (also related) via a drop down box, and then enter an amount and date of the expenditure. Each expense is an individual record on table number one. Also on the table is a summary of the amount that correctly updates when a new record is added, changed or deleted.
The second table(related to the first) is designed to display summaries of each category from the first table, which it does, but not dynamically. A found set from the first table does not pass through to the second table, rendering it useless for the purpose of looking at reporting periods. The only (non-solution) I have found is to delete all records from unwanted dates not in the found set from Table #1 and then click on each fiedl in table Number 2. Not acceptable!
Preview does display the categories in table number 2 with summed expenses correctly (after clicking on each field) , but that's it. Nowhere to go with the data I need. Can't export it to Excel or post on another FM report , which is the purpose. Worst is that it does not auto -update as new records are added in table numner one
I'm looking for a workaround, or solution or maybe insight on why the found sets do not pass through to the second table. Any help would be greatly appreciated.
P.S. I use FM 10. Anybody know with certainty if 11 or 12 addresses this issue?