How would I create a repeating group where the left most row is static (Car 1, Car 2) and the columns are scrollable dates?
Hi! Can u describe a bit more? Sounds like u nave car for rent purpose, which u store in database as cars, and list of dates available for this car? Can u show database, can u show it’s connection?
Thanks for responding.
I am still planning out my database but I think it will look like this:
Cars: Unique ID, Number of Seats, Color
Trips: Unique ID, Depart Date/Time, Depart Location, Arrival Date/Time, Arrival Location, Car ID
Trip Segments: Unique ID, Trip ID, Depart Date/Time, Depart Location, Arrival Date/Time, Arrival Location, Segment Number
The list of Cars will always be the same and I want them listed Vertical, then each Car has Trips with at least one Trip Segment. The top row should be columns of dates.
Here is an idea of how it could look
What does “trips segment” mean? Is it part of whole trip or smth else?
That is correct a trip is made up of at least one segment.
So trip number 1 could have four segments. Trip 2 could have 2 segments. Like a multi location itinerary.