Generate multiple invoices?

[db]

Can anybody help me by explaining how I can generate a series of invoices in one process?

As you might guess, - I'm not very good at writing scripts...

I have a database with several tables. I want to generate new invoices in the invoice-table from a selection in the member-table.

[CyborgSam]

db->

Welcome to the Forums!

I'm being very general and making guesses about what you're doing. First, you'll need a relationship between members and invoices, ideally using serial numbered keys. Then you'll need a layout for the invoice form. If you use a list layout, you can use the relationship directly (without any Finding to limit the found set). If each invoice requires a separate page, make sure that the layout takes up a full page.

[db]

Thanks.... but I have gotten a bit further than that.

The relations are established, the layouts are created and I'm using a script with find and constrain find to limit the selection to only those members who will recieve the invoice. I'm also using a "line-item" table to store the invoice-items.

The invoice-layout is connected to the invoice-table and there are a total of about 7500 older invoices in the tables.

My problem is how to create new invoices on the selected members automatically (there are about 200 members in this selection).

I tried to use a loop in the script, but I could not get it to work. Probably because I don't know enough about scripting....

[CyborgSam]

We'll need more info to pinpoint the issue. Can you post either the database file (if you do, remove all records to protect confidentiality) or the script?

What did the loop do/not do?

[db]

I'm afraid posting the database-file will do no good, - it's all in norwegian, and that is why the language in my posts might be a bit odd sometimes....

Let me try to explain my "needs" by asking two questions:

1. Is it possible to do this automatic creation of invoices? There are three tables involved; member, invoices and line-item, with all the "normal" fields, and some more. I want FileMaker to create one new invoice for each of a selection of members, and to use the same "invoice-text" and amount selected from the line-item table.

2. If it is possible, what would be the theoretical way to do it/ the process? Where to start, what to select, which relations would be necessary, how to create new invoices, etc....