table relationship question
Hi, have two tables...
I want members to be able to save as many adverts as they wish.
The three methods I can think of are....
1. A column in 'member' called 'savedAdvert' with a comma separated string of advert id's which increases as more are added.. like '123,143,15,235'
2. A column in 'advert' called 'memberSaved' with a comma separated string of member id's which increases as more are added.. like '123,143,15,235'
3. Make another table called 'SavedAds' with two columns of 'memberId', 'advertId' and each time a new advert is saved it adds a completely new row accordingly.
Which is the best method?