Hi all, I have searched the forum without finding answer to my doubt.

I am setting up an invoicing system with FM10, and I have two tables, one with orders and one with line items.

I have set an input layout where the user inputs in a portal the line items for each order.

Now I am setting up a print layout, the idea is to print a table with all the line items of a record. The table should be dynamic and show as many lines as the line items in the order.

I think that the idea is to put column names in the header and than line item fields in the body. Unfortunately it shows only the first line item.

How can I obtain what I am trying to do?

Thank you, regards

Something like the attached?

Will someone please fix the problems with downloading sample files on this forum!!!!!

Unable to download the file ONCE again!!!!

Ilnave,

A few pointers.

1. You should not use a portal to print invoice line items.

2. Your layout should be based on the line items table, not the header / parent table.

3. You need to use a LIST layout.

There are several Invoicing solutions out there where you can see how invoices are printed. This one is free : http://www.fmstartingpoint.com/

sorry for my late reply, I did not receive email notifications.

I have trouble downloading the file.

Thanks

Hello djlane,

thank you for your help:

1) I am not printing the portal

2) I am selecting the "line items" table

3) Indeed, the list layout automatically "designs" the layout as I meant, BUT it shows only the first item , why?

thanks

Ok, there are a few updates.

I have two related tables, one with orders and one with line items for each order. Data input happens through a portal for line items.

My need is to setup an invocing layout.

I understood that the correct layout is the list layout, which puts in the body the order line items.

Everything perfect... except... it only shows the first line item of a certain order, not all of them

Anyone can help? thank you

Regards

Attached is the file that can't be downloaded in the previous post.

orders.zip

Thank you, and sorry for my late reply, I am not receiving notifications, and have to fix this as well!

I have downloaded the file, but how can I edit it in order to see how it is built?

I cannot see any layout feature if it remains in user mode.

Regards

ops