creating report with entries from multiple tables

[L3Le]

hi everyone, I'm new to this forum and quite new to filemaker. I have not so many skills in developing databases except for the basical ones, so I hope you'll help me... this is not for my interests, I'm working free for a person who really need it.

I've searched google for a lot of time but I wasn't able to find anything...

I have to make a report of my database: I have two tables, the "registrations" one and the "buys" one. Both of them have got a "total amount" field. I want to make a report which tells me every registration and buy which has been made in the same day, adding a subtotal field that is the sum between the money entered and exited (I have set the "buy" amount field to be negative). I have related the "date" field, but I'm only able to display fields/records from one table. What can I do?

thank you everybody ;)

[bcooney]

It would be helpful to understand more about your data and why you think that Registrations and Buys belong in different tables. The easiest solution is to have them be in the same table with a field (Type) that differientiates them. Then, you can easily product a sub-summary report.

[L3Le]

hi and thanks for your answer

I'm making a database for the registrations to my leisure center (it's for my priest). A registration (which is stored with the parent's name and data, like the telephone number) has to store the children who are registered (in the "user" tab, which is related with the registration one); then the database calculates the amout to pay and assumes it has been paid depending on how many children are registered and for how many weeks. buys are stored only with the amount, the date and the description. I have to make a report which sums both the money fields.

I have thought to make only one tab, but it looks like it would be a lot artifact to have two forms, with different fields and functions, for only one tab and only one type of record. Buys would have the "children id" tab; it would be rather nonsense. I'm wondering if there isn't another way to do this in a cleaner way...

Another thing I thought is to make, everytime a registration is saved, a "buy" record copying the total amount from the registration (and updating it if necessary; I guess it would be done with the Reference Value) but I didn't know how to do this. maybe with a script OnSave? I'll try next, maybe it will work. If you have a better way to suggest me, you're welcome; thanks for your support for the time being.

[bcooney]

I still don't understand your "buys" entity.

Why not have a People table? People can have Parents (which is a self-join back to People) and a Type (Parent/Child).

To me, each Registration record is for a Person, storing their ID, ProgramID for which they registered, Qty (I don't know, weeks? days?), and cost.

I wouldn't assume payments, I would have a table of Payments (either a child of Registration, or a child of the Person who pays).