how to assign a value to several others

[gavlaar69]

I am creating a table to go into a database for a hotel
In order to sort my database each guest is assigned a customer_id
each booking is also assigned a booking_id
I need to create a table which shows the booking_id and the guest_id, and i'm not sure the best way to do this without going through hundreds of individual rows, as some guests can have more than 1 booking_id

Any help would be appreciated

Thanks

[FDibbins]

Hi and welcome to the forum

Not sure if this will help at all, but if you have a 2-column list (Guest_Id and Booking_ID) you could sort on Guest and do it that way?

What are you planning on doing with the info once you have it?