Reservations system

Occasional Contributor
Hey everyone,
I'm having a small issue I hope someone can help me with.
Im trying to make a simple booking system, where I would enter people into a list (columns: name, last name, other personal data columns, lookup column to a trip id (separate list) and a reservation ID. This last one would be auto generated, it can't repeat for another reservation, but obviously need to repeat for people on the same reservation. The thing is, a single reservation can hold any number of people and I can't see how to set thing up, so that for each new reservation I am able to somehow contain these individuals within reservation and also make sure the reservation IDs are used in order.
0 Replies