I'm at a complete loss.

I have figured out how to get all of my data in, but now I need to print reports and I'm screwed.

3 files-

Lists

Line_Items

Notes

Multiple line_items for every list, and multiple notes for every list.

I need to print a report that shows the items from the lists file as well as every record in line_items that has a matching list_ID and every note in Notes that has a matching list_ID.

This sounds like it should be easy, but when I set up the report I can only get the first line item and the first note. I need to print all items for that list. When I run reports out of Line_Items I can get all of my records for a list and when I print out of notes I can get all notes for a give List_ID. I need to summarize all of this info on 1 report.

I know I've been posting quites a bit and I'm sorry if I'm overusing the forum, but I'm on the wire here.

Please post your toppic only in one forum.

Thanx