Yeah I think your mentioned approach is going to be the way to go; you'll need a record that links a vendor (or customer) to a trip, and then your trip record will contain the list of all of those child records associated to it