copy contents based on multiple tables

[d²c]

Hello,

I own the book "the missing manual", searched it and didn't come up with an answer for my problem. Google... nope.... forum... nope... so here is my post:

Whenever a student is placed in a grade, fm should automatically place new records in my payments table with the information about the costs specific for that grade. In the row of data would also be a field paid that stays null as long as the student didn't pay. This way I can easily report what's been paid, and most important, what's not!!

I included a file with the basic tables, feel free to update this file because it would mean a great reference to me..

Can somebody please help me on this one?

thanks in advance!

greetz

D

students.zip

[Tim W]

Hi D,

Not sure this is what you want, but related record creation has to be triggered by some event. Button, script, or both is needed to make your related record. Made some modifications to your file and the result is attached for your viewing.

No Relationship is needed to the grades table since it seems to only be a lookup table. I added a new TO (table occurance) for the payments to costs tables for clarity. Some fields in the payments table should be looked up values from costs, look and see what was done.

Hope this helps you along in your project.

Tim

students.zip

[d²c]

This only copies one cost into the table payments.

When a student is registered, he will be added to a grade (classroom), let's say 1 (first grade).

Now, to be a part of this grade, there are different costs to be paid during the year. Each month money for lessons for example. I know that the costs are related to each grade. So what I am trying to do is to copy the records from costs into the payments table for each student. In the beginning of the year I will have many empty records, but at the end of the year the student should have paid all his/her costs.

This way I will be able to see what's been paid and what's not.

The script should see which students belong to which grade, and add a record for every cost in the payments table.

Is this possible?

D

BTW: tim, thanks in advance for your help so far!

[Tim W]

Sure!

I need to see more of your structure. Do you have a more complete file to look at? I had to guess the use of too many fields.

The script could be set to run on every cost record for that gradeid, creating a separate payment record for each.

Give me an example: john goes to the 3rd grade and has to pay a fee for? and ? and ?

then sally goes to the 1st grade and has to pay a fee for ? and ?

Tim