SharonGordon

Many thanks! I really appreciate the help! Sharon

Is this what you were thinking? Add a global field to my summary table and join it to the field in my detail table that I want to filter on. Then when I enter the filter value into the global field in the summary table, that should filter the detail records? Thanks, Sharon

Hmm, could you say a little more about how to filter a relationship? I know I was skimpy on details...I can post more if it looks necessary. Thanks! Sharon

Hi all! I could use some advice on performing a find... Namely, I have two related tables: a detail table that contains detail records, and a summary table that contains a calculated sum() based on an amount in the detail table. (For other design considerations, I need to have the calculated sum() in a separate table.) I would like to filter the detail records based on one of the attributes in the detail table so that the sum() in the summary table reflects a total amount only on the found set of detail records. So, I created a script - here's a rough description of it: Go to the summary layout Find all records Enter find mode Set field detail.amount to the filter value (The detail table is related to the summary table) Perform find After running this, the summary result reflects the total amount of all of the detail records, not the found set I was aiming for. Any ideas would be really appreciated! Thanks, Sharon

Hi all! Any advice would be really appreciated... Say I have a checking-account like application: I have a transactions table that stores the withdrawals and deposits to the account. And let's say I have a summary field that gives me a running total for the account. Then I would like implement the following process: 1) Allow the user to pick a year to report on. 2) Look up the starting balance for that year in a table. 3) Generate a report that adds the starting balance to the running total. More specifically, let's say the report shows the starting balance on January 1 of the chosen year then shows subtotals for every month. I'm okay with steps 1) and 2), but I could use some suggestions for step 3): how do I pass the starting balance to the report in such a way that it is added to the running total once at the beginning of the report? (I'm okay with the grouping part of the report to show the monthly subtotals...I'm just not sure how to initially add in the starting balance.) For annoying reasons, let's say I can't store the starting balance as a deposit transaction in the transactions table. And let's say that the table that stores the starting balance for this account also stores the starting balance for other accounts. Phew! Many thanks in advance! Sharon