BPHusker
05-06-2008, 06:05 PM
Ok, I have a report that I am creating for a database that is our semester project in a class.
The report is made up of data from 3 tables (Guarantor, Guarantor_Phone, Student). The report first lists the parent (guarantor), then their phone number (can have more than one), then their associated student (can have more than one).
The problem I am having is that for each phone entry (ex, Home and Cell), it is listing the associated students after each one.
Here is a screencap of what I am getting.
http://i32.tinypic.com/2po2x54.jpg
I created the report with the wizard and then changed it around. Pretty much I have a GuarantorID header, PhoneID Header and a StudentID Header, if that helps out at all.
The report is made up of data from 3 tables (Guarantor, Guarantor_Phone, Student). The report first lists the parent (guarantor), then their phone number (can have more than one), then their associated student (can have more than one).
The problem I am having is that for each phone entry (ex, Home and Cell), it is listing the associated students after each one.
Here is a screencap of what I am getting.
http://i32.tinypic.com/2po2x54.jpg
I created the report with the wizard and then changed it around. Pretty much I have a GuarantorID header, PhoneID Header and a StudentID Header, if that helps out at all.