what is the best architecture for a booking system,

i want each "booking" to have a list of items allocated to it

i have considered a table for bookings, then a table for every item on every booking but this could get a bit big!

any suggestions/ ideas?

See if this will get you started.

http://www.nightwing.com.au/FileMaker/demos7/demo705.html

thats great for some other aspects of my site so thanks.

however, building on the example i would want to book multiple rooms on one booking.

You could add a global field for storing the number of bookings you wish to make, and then add following script to Rays template.

If [ Get ( LayoutNumber ) = 3 ] 

     Show Custom Dialog [ Message: "How many bookings do you wish to make"; Buttons: “OK”; Input #1: Availability::gCountOfBookings ] 

     Set Variable [ $counter; Value:Availability::gCountOfBookings ] 

     Set Variable [ $FromDate; Value:Availability::gFromDate ] 

     Set Variable [ $ToDate; Value:Availability::gToDate ] 

     Set Variable [ $Capacity; Value:Availability::gCapacity ] 

     Set Variable [ $Type; Value:Availability::gType ] 

     Loop 

          Go to Portal Row [ Select; First ] 

          Exit Loop If [ Get ( LastError ) = 101 ] 

          Perform Script [ “Place Booking” ] 

          Set Variable [ $counter; Value:$counter-1 ] 

          Exit Loop If [ $counter=0 ] 

          Set Field [ Availability::gFromDate; $FromDate ] 

          Set Field [ Availability::gToDate; $ToDate ] 

          Set Field [ Availability::gCapacity; $Capacity ] 

          Set Field [ Availability::gType; $Type ] 

     End Loop 

End If 

--sd