Working with departure dates

[Dega]

I already have a table called TourName and those names are already in the table. One tour may have several date departures during the year and some only one departure.
I need to show departure dates (TourDates) for those respective tours and then have the form display those departure dates.
Should I create another date table or just add more columns to the existing TourName table ... but I have doubts that would work well.



Thanks for any advice.

[Bob Fitz]

Hi
In my opinion, you need another table for the tour start dates.

[pbaldy]

You don't want multiple fields. It sounds like you need a table related one-to-many to the TourName table.

[Dega]

Thanks for the feedback.

A one-to-many from TourName to TourDate or the opposite.

[orange]

1 tour Name to Many Tour Dates

[Dega]

Thanks very much