Quote:1. In the .dsr file: New Database->Forms->Redesign a form->New
database->Main report card. On the "violations" sub form, "violation code" layout element, I will import data into this field, and the codes will be according to the "summary" sub form and the "CIN," "CKL," etc. layout elements. With each succeeding record, I want the "CIN" layout element to count each "CIN" from "violation code" from the retrieved records. I think a loop is what I need.
Okay, I think I see what you are trying to do here. Each record has a single violation code on the Violations tab. The Summary Tab is meant to contain a running total from all "previous" records. Is this right?
If so, the problem is with the concept of "previous". Databases store records in a randomized order. Just because a record is "before" another does not mean it always will be. You can resort your records at will, thus blowing your running totals. This is the kind of information that should be generated on the fly, as needed, using a Report or a Mass Update. Would you like an example of this?
If so, do you want it to print to a printer or display on screen?
These report cards appear to summarize violations by state. Is this correct?
Quote:2. In the .dsr file: New Database->Forms->Redesign a form->New
database->Main form. This is just a bunch of command buttons. Using the "by cost" command button, I want that button to retrieve the records from the "main report card" database according to the "enter beginning date" and
"enter ending date" and put the information into New
Database->Reports->Redesign a report->New database->By cost. I cannot figure out how to do this. How do I do that?
The Inside Sesame article I mentioned has examples of doing exactly this. See the example of using GlobalValue. Also see the example of using date ranges for how to set the date element in the Retrieve Spec.