The best way to go about adding "highlight" entries to a specific record

[NathanielB]

If I have a table, lets say trip_information.
Then for each trip there is are trip "highlights".
Each "highlight" contains a title and a description.

You don't know how many highlights there will be per trip, and you don't want to create one field in the table where someone would just paste HTML.

How would one go about bulding a relational-setup where you can have such a thing? A great example is this:

http://ca.contiki.com/tours/122-european-magic

You see there's 'Trip Highlights' with a few pictures, a title, and a description. Surely all of these are not just HTML pasted into a field - right? :S

[r937]

there should be a one-to-many relationship between trips and trip_highlights

one row per highlight, so you do not need to know how many there will be

each highlight is related to the trip it belongs to with a foreign key

[NathanielB]

there should be a one-to-many relationship between trips and trip_highlights

one row per highlight, so you do not need to know how many there will be

each highlight is related to the trip it belongs to with a foreign key

So in the "trip_hightlights" there will be every single trip highlight entries no matter what the trip, its just a big general table of trip highlights and it's tied to each-other by the trip ID?

[r937]

yup

[NathanielB]

yup

Great, thanks!
I guess then the same would go for the itinerary setup, like here:
http://ca.contiki.com/tours/122-euro...agic/itinerary

skipping the little pointer list, the detailed itinerary list of the days; same situation? Every single itinerary entry regardless of a trip will be stored in one table and each entry would be related to a trip by ID's.

Thanks again r937/Rudy (i'll make that assumption based on your domain in your signature ), you've been a life-saver though this!