print 2 different lines (portals)

[downbylaw]

Hi guys,

in my invoice solution I have 2 different lines with object in it (1 with items and 1 with services). In my invoice layout I also have 2 different portals for these 2 lines.

But I'm have some difficulties printing these 2 diffrent lines on the print layout. I already tried printing one of the line items and that worked perfectly.

How can I make this work?

Thanks

[bcooney]

Are the two portals based on the same table? (They probably should be, if they only differ by line item type). If so, just design the print layout using the child invoice line items table.

[downbylaw]

Thanks for the reply. No, both portals are based on a different table. Is this wrong? I have one table with all the products I rent and one table with all the services. I wanted to keep them a part.

Whats your recommendation?

Thank you!

[bcooney]

It's very difficult, then, to print an invoice if you have two children tables.

I'd combine Services and Products into one table, with a Type field.

[downbylaw]

I've uploaded an example of what I saw once. It's an invoice with 3 different categories ('verhuur', 'verkoop' and 'diensten'). If one of the area's is empty than that are doesn't print.

How would I need to combine these 2 tables into 1?

Thank you

[downbylaw]

any suggestions please?...

[comment]

I'd suggest you provide a list of fields that are necessary to describe a product, and of those that describe a service.

[downbylaw]

I think it's absolutly possible to do something like that. Maybe I'm not explaining it right?...