I'm trying to create a database to use as a booking system for a boarding kennels. I need to enter the arival date and departure date for each pet and get filemaker to calculate how many kennels are in use on each night. How would I perform this calculation? Could it then be used to create the invoice?
Really don't have a clue how to do this so any help would be greatly appreciated!