Linking one record to another record

Forum|Forum|14 years ago
May 4, 2011
2 replies
702 views

I have two tables:

Ads

Articles

I've created a way to link specific ads to specific articles so that relevant ads are shown to whoever is reading an article. However, I think my method is going to require a lot of upkeep. I thought about entering keywords for the ads and articles, but I wanted it to be more specific so the results were more relevant.

How would you go about it?

This topic has been closed for replies.

A

Adam Cameron.

Inspiring

Don't you just need a link table to implement a many-to-many relationship between those two tables?

--

Adam

S

Squiggy2Author

Inspiring

Correct. The problem I'm having with the entire thing is that when a new ad comes in, you have to go back through every old article to link the relevant articles to that ad. I'm not sure there's a way around that though, unless I go back to using keywords instead.