Thanks for the reply.
It isn't doing what I'd like it to do, however. To clarify the
task, here is the *current* configuration of the page as provided to me
by the design person. This page is configured as one large "details"
section. No headers or footers were wanted. The primary key for this
report is Job Number (JobN) from a table named "OpenJob" Each page of
the report is devoted to one Job Number, and we have 33,000 job numbers
and 33,000 pages. On the page along with the job number are dozens of
design items completely filling a legal size page (no database
definitions were present when I was given the task of configuring
inserting the database fields). For each of these items (
except for the records I have questions about) there is one record for each job number.
In the center of the page, there is an area devoted to inventory items
(Material) used with each job. This section allows for up to 12
inventory items for each job number. This makes it different from the
others. With those others I just need to locate a field from the Field
Explorer, and drag that field to the appropriate design box in the
form.
At the time I'm attempting to add the group, I've set up the four
additional tables I'll need for this job, and added items from those
tables to the form. I've also added the "Materials" table to the
Database fields in Field Explorer, but have not yet selected any fields
from this table to the form, and I've not added any SQL queries
(Commands) to the Database fields list.
So I then go to "Insert, Groups". I'm basically asked what field I want
to sort and group this group by. I don't care about sorting, I'd prefer
the records were listed in the sequence they were entered in the
database, but there isn't a field for that in the table itself. I will
only want records from the Materials table that correspond to the job
number from the OpenJob table (for which there is one per page) and
there are no joins yet specified in the "Show SQL query" menu item
since I haven't added any items from the Materials table to the form
itself.
Since Materials.MccNumber is one of the fields I will eventually want
to add to the form, I'll choose that as the answer to the question
above. I don't care about the "Keep Group Together" item since the list
will not be spanning pages. I was NOT asked what other fields I want in
this group.
That menu choice includes this statement: The section will be printed on any change of: MCCNumber.
NOW...this make me think this isn't what I want, but I'll let it go and see how it works.
This created a Group Field Name. As noted earlier, the design choices
made prior to my getting involved in this disallow any headers/footers.
The preview doesn't show this recently created header, only the design
view, so I'm okay so far.
You wrote:
Are the fields you need from all 12 records exactly the same? If so,
put one set of fields in the details section.
They will each contain the same fields. But I've not been prompted
for inclusion of any fields (save one) to the group. Do I choose them
as a property of the "Group Name Field"? I've inserted the group name
in the section Group Header #1 (which cannot print, due to the design
decisions made). I can add fields to the "Materials" section of the
form, but I'm right back to my initial problem...how to include the
multiple records.
IP Logged
