I am facing new challenge in my FM_Sales_Solution, which is based on the following tables:
INVOICES ( Id, Date,Name, total_ItemsValues Etc..)
ITEMS ( Fk_Invoice; Fk_Products; Qtt; L_Price, Valuesline)
PRODUCTS( Id; ProductName, Description; SalesPrice)
The printed invoice is based on the Items table as it should be. Some Product that I sale, has long description text, some details comes in multiple lines( some takes 1 line, others more than 10 lines).
I need to show the Descriptions of each product in the invoice line.
How can I do, if the amount of data in the Description field is variable?