Hi. I am an experienced web developer and right now I have a client who requires a somewhat complicated site to be made with WordPress, which I have not used before. I understand how I would build this site from scratch, but I need some help getting started with it in WordPress.
This project is basically a database site. I need to keep track of three tables of data -- as well as their relations. As an example, the three tables could be:
Then in a relations table, each category would have it's own field/column which is used to show which entries are related to each other. For example, an entry might be:
Car: Maserati, Colour: Green, Driver: Pierre
Then on the site, if I open the Maserati page a side panel would display links for Green and Pierre (as well as any other Drivers and Colours which were associated with this Car).
How would I build this type of functionality in WordPress? Are there plugins? I am open to any suggestions which would achieve this functionality.
Thanks in advance! :)