New to filemaker need help with database for room bookings

[alf1965]

I have a database that consists of inventory, Invoicing, and purchasing. The items are rooms by date.
I have it set up so that we purchase blocks of rooms by date. Example 10 rooms for 10/1/2008 purchased and now show up in inventory.

For the invoicing side Im having trouble- The rooms get booked by start date and entering number of nights. Example customer bookes 3 nights starting on 10/1/2008. On backside I want to be able to run a script or something that knows this customer has actually purchased 1 room for 10/1/2008, 1 room for 10/2/2008, and 1 room for 10/3/2008 so that it can be deducted from inventory without having to make the customer purchase the rooms this way.

Is there a script or a calculation that I can use to get this information?

 

[JeanW]

Use the CF you refered to in your other post.
Parse out the dates and script vreation of records with a script. For each date a record, with the parent key of the customer as relation key.
All of this in a line item table between customer and room.

This way the room/date/customer are linked together.