Help with reporting, tables, relationship

[alfmaui]

I am brand new to filemaker and this forum. I appologize if I'm not under the correct topic i think I am. anyhow...

My issue:

I have a database. There is a table of room bookings associated with a billing table by index. This works fine. I have another table that holds the block quantities of the rooms and its not associated with anything other than the type of room. The billing table is not associated with the block quantity table but I am trying to do calculations and have a report display the number of block quantities - the number of rooms booked. I tried creating a joint table with the calculation but this doesn't work. Is there an easier way to get the report to work with calculations without the 2 tables being related? The database has already been created and data has already been entered. Help.

[Don_Macaroni]

What is "block quantity" in association with Bookings? Please be more specific...

[alfmaui]

The block qty is the amount of rooms available by type and by date. Bookings is the amount of rooms booked by type, date, and person.

[Don_Macaroni]

If I understand it correctly, then you can do this with calculation fields and use Sum(field). You would have to make appropriate relations though. The Sum(field) would simply count records where it matches the relation.

Can you make textual diagram of how your tables are set up?

* Do not confuse 'Sum(field)' with a field that has type 'Summery'.

Edited April 18, 2008 by Guest