What tables do you have at the moment?
I would see that you need a field in the TRIP record for maximum capacity (e.g. 50).
You would have a CUSTOMER table and a RESERVATION table. These would be joined thus:
CUSTOMER ---< RESERVATION >--- TRIP
Remaining places on each trip would be calculated with a field in the trip table:
= MaximumCapacity - Count ( RESERVATION::ID )
So what you are doing is to subtract the number of related reservation records from the maximum capacity for the trip.
Does that help?
It gives me a place to start. I currently only have one table that has customer info and fields for customer totals. I`m still real sketchy on how relationships work. If I can pick your brain just a bit more...
On any given day we have 25 different trip times. So, if will the max field relate to any day or will I need to set something up to define individual dates?
Each 'trip' would be a different record with a date and time.
If you wanted an overview of what was going on on any day, you could have another table for DATES:
CUSTOMER ---< RESERVATION >--- TRIP >--- DATE
The relationship between TRIP and DATE is via the date field in each.
I think I need to watch some more tutorials on relationships. I feel a little out of my "pay grade" as it were. You give me hope that what I need to do is possible.