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....

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....

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.