4 posts by 2 authors in: Forums > CMS Builder
Last Post: October 15   (RSS)

By mbareara - October 8 - edited: October 8

Hello

i'm building a website for restaurants reviews.

I have a table with hundred of restaurants. 

And i want to build a second table with articles called "The absolute best". Something like "the absolute best pizza in one city" or in another.   

This second table has a Title, a Image, a short content, and TEN or less Restaurant with a short comment for each restaurant.

I could have a very easy article and insert in to a filed content the ten restaurants. But i would have a more smart table, creating 10 field RESTAURANT 10, RESTAURANT 9, RESTAURANT 8 and for each a comment. Just to recall in the article all the information stored in the first table for each item.

AM i on the wrong way?

Thank you

Orazio 

Hi Orazio,

Yes, I think this is definitely a valid way to set up this section, and while it's a bit repetitive to set up so many fields, it's fairly simple. There is a way that you could do this without having to duplicate the restaurant+comment fields so many times with a Related Records field, but that is quite a bit more complex. Though if you're interested in learning about it I could give you a general explanation of how it could work.

Thanks,
Daniel

Daniel
PHP Programmer
interactivetools.com

Of course! I'm interested! Thank you for sharing your solution!

Orazio