Hi,

I have a database with adresses of my supplies&customers. Now I want to chosse an adress and send an inquiry or Invoice to this adress.

I tried this tutorial: http://www.filemakertoday.com/invoice.htm

but I want to have so many lines as I need for the products, not a constant number.

How can I solve this problem? Or do you have any better ideas?

Thanks

[i'm assuming you mean "email", not "mail"; 'cause mail would just be printing the quote/invoice.]

In situations where I needed to "flatten" multiple fields in multiple rows of a portal (or relationship in general), I've used the GetRows() Custom Function, by Bruce Robertson; also requires the subsidiary CF GetNthRow. It's at Brian Dunning's site:

briandunning.com/filemaker-custom-functions/list.php

It is also useful for printing "portals."

The only drawback is that it seems you have to "hard-code" the field names, as the parameter is text. Please tell me anyone if I'm wrong.

Edited September 2, 200718 yr by Guest