Hi, I'm really lost here. I'm now thinking I've screwed up somewhere but I'm also kinda stuck with this problem...

I have a main database which clients use to enter projects in (construction company). The only data this one contains is CreationDate, IDnumber and a few lookup fields.

All other data like contractors, materials, time etc., are in line items (related) and shown in portals. Adding a new item to either of those databases sets a field with the current (main DB's) IDnumber so it will show up in the relative portal.

Thats all working well, no problems there.... but if I want to print a temp report showing subs on all entered data, it does not work.

Let met sum this up:

Main DB: record with IDnumber 0018

rel. Materials DB: 10 lines, all with one cell populated by 0018

I've set the subsum to break on a relationship (Main DBnumber = Rel DBnumber), using the IDnumber as a breakfield.

Anyone have a hint for me? I can't see/find/think of one...

Thanks in advance

JP

hehe talking to myself again... anyway I've got this thing working for me now. I'm not sure this is the right way to do it, but the output is just as I want it.

On my layout (for printing) i have a Leading Grand Summary, holding just some basic text. In the bodypart below that I placed 7 portals (with 20 lines each), and have set the sliding to 'only directly above' and 'also reduce the size...'. When I select the IDnumber (using a find in the Main DB), and preview the raport its all good: portals shrunk and line up nicely underneeth eachother.

The lay-out however looks real long (7x20 lines plus text..) but printing records with 20 lines in each portal still breaks up over pages as it should. My problem so far is solved. All I have to do now is create summaries for amounts etc... but I'll figure that out too.

oh and JP, sleeping longer than those 3 hours a day will eventualy do you some good!