Hi everyone, basically my problem is this:
I am using an Access 2000 format.
And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the project name, one primary point person for it (1:N list from a separate table), other details, and a manually entered tracking number, which is the primary key.
Now, I also need to put down the legal entities, business managers, financial controllers, and supporting staff, and since these just come from the same pool of people I decided to use subforms for them so I'd only need to type in their names once in the separate table and just select them on the main form if i need them. The subforms are properly working -- they allow me to select one or more entries for the other. Form's working perfectly too.
My problem is that the report I build--no matter how i group or sort!--displays only ONE entry from those four subforms/subtables, and then repeats everything until all the combinations have been entered. Say I have this Project Alpha, with Bob as my point person. For legal entities involved in this Project Alpha I have Entity A, and Entity B, and for business managers I have Manager R and Manager S, (and say we leave the others blank.). I have other details of course but, essentially this is what happens on the report, and where I have problems with using subforms:
Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554
Legal Entities Involved: Legal Entity A
Business Managers Involved: Manager R
Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554
Legal Entities Involved: Legal Entity B
Business Managers Involved: Manager S
Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554
Legal Entities Involved: Legal Entity A
Business Managers Involved: Manager S
Project Name: Project Alpha
Point Person: Bob
Tracking Number: 89554
Legal Entities Involved: Legal Entity B
Business Managers Involved: Manager R
.... :confused: The same project has four separate entries on the report just because I had two legal entities and two business managers selected in the subform! Imagine how many repititions I have with having multiple financial controllers and supporting staff... so I don't know what to do since I still want to retain the subform structure in the report. (I could just put multiple fields in the original table but this would defeat the purpose of access).
Anyone out there have this same problem before? I can't use the "view by" mode used in Access 2003 since I am formatting this using Access 2000 for an office that can't upgrade all its computers to '03. Not that that would matter, would it? : (