Merge or Portal for invoice?

Posted on 2005-05-08
Medium Priority
Last Modified: 2010-04-27
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?
Question by:Issaquah
  • 3
LVL 28

Expert Comment

ID: 13961600
merge fields can help, but not really as you'd like it.
Portals can used, but not ideal; it is rather a solution for display only. Use a sub-summary in yr layout, and it will resize itself according to the amount of related records.
Otherwise, if you'd use oprtals, use sliding cells; my problem is for correct words as I do not use an english version:
Select cells to be butted, then
Format menu/last option down, then check the option to slide objects towards top. When you do this, you should select all objects in the portal othewise it won't shrinh properly. Effect is visible only in preview mode.

Author Comment

ID: 13968035
Maybe I am not stating the problem correctly. Here is what I am trying to do:

I make three visits to a client called "Sam". On April 15th I fix his computer which takes two hours. On April 20th I fix his network which takes 1.5 hours. On April 25th, I fix his printer which takes .5 hrs.

I would like to have a way to have the date, the hours and what I did show up all at once. It would look something like this:

4/15     Fix computer     1.0
4/20     Fix network       1.5
4/25     Fix printer         0.5

Thanks again!
LVL 28

Accepted Solution

lesouef earned 2000 total points
ID: 13970062
I got it right: it is a perfect application for a portal to a 2nd table containing interventions data.
And can also be done with 3 repetitive fields, put side by side.
Let me know where this is not clear. Need an examlpe?
LVL 28

Expert Comment

ID: 14228544

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question