I have a DB with records for that list what I have done for clients. There is a new record for each visit with each client. Among other things, the records has field for the visit data and the task done on that date.
Now I would like to create an invoice which would include the field with the items done on each visit and the date of the vist.
I have tried using a Portal and it works somewhat. All the items for each day and the date of each visit automatically appear on the invoice layout. But there is a problem:
The "cell" for each repeition has to be fixed to a certain size. This means that if my items for the day add up to five lines, I have to make the cell five lines tall to all items are visible..but if the items for the second vist are only two lines, then the second cell of items has a lot of blank space.
Would a "merge" field suit my needs better?