Creating unique records based on dates and/or date range
Hopefully this will make sense, as I have a customer with FileMaker database that holds Hotel confirmations and costings. The data is fairly straight forward.
The customer would like to generate travel itineraries for their clients based on each of the days client is traveling. The key date is based on the check in day in a particular hotel.
The itineraries will contain ad hoc text of things the clients can do while they are in a particular location for each given day.
What I can not get sorted out in my head and this is a specific customer request - they want to refer to each of the travel intinerary enteries as a day number.
Client checks into "Hotel A" on January 1st and checks out on January 2nd this should be referenced as DAY 1.
On January 2nd client checks into "Hotel B" and checks out on January 5th.
These dates look like this:
Jan 2 = Day 2
Jan 3 = Day 3
Jan 4 = Day 4
Jan 5 = N/A
Records in [TripDetail] table look like this:
The customer will create itinerary information (text) for each date/Day:
This process is completed after all of the hotel arrangements have been created and confirmed.
What I am visualizing is a script that will go through the above referenced table and create a day record for each date and place it in a related table. The customer then can recall the related record(s) from the particular hotel record and input the required travel text for each day.
If anybody has any thoughts or insight on this, or some advise on possibly a better way of doing this. any help would be greatly appreciated.
<!-- POLLS --><!-- FILES --><!-- SIGNATURE -->