Hi all. Firstly I am loving Bubble and all I have been able to achieve so far but I am stuck on one aspect
I am attempting to record vehicle based trips. Each Trip has at least one or two Vehicles - an RV towing a car for example. Each vehicle has a start odometer and regularly recorded odometer readings to be able to calculate distance traveled within that Trip
I therefore have a Type called Trips and a Type called Vehicles.
Fields - Trip Name
- Start Date
- List of Vehicles
Type - Vehicles
Fields - Vehicle Name
- Model etc etc
I can save trips to the database with its list of vehicles OK. I am now really struggling with where to nest the start odometer and regular odometer records for each vehicle on the trip. The odometer of course is related to its Vehicle. Should odometer be a type or its own and then nested as a list either in Trips or Vehicles, or just a field within either Trips or Vehicles. How would I then save them to the database
It should be noted that as well as each trip having multiple vehicles, each vehicle can be used for multiple trips.
I hope someone can stop my brain going round and round in cirlces