Here's a tricky one that I have stumbled on when building a new site. The site is a whisky site where I have two categories.
2. Single malt
I'm using custom metadata to add data about both the single malts and the distilleries. What I want is a connection between a specific bottle and a distillery. So when a I read about a single malt bottle I want to show the custom metadata for the bottle but also the metadata from the distillery the bottle comes from.
For example, I have a post which is called 12 year old Balvenie. The bottle comes from the the Balvenie distillery. I want to show metadata that I have added to the bottle post and also the the Balvenie distillery.
Name: xxx (single-malt post)
Age: xxx (single-malt post)
Distillery: xxx (single-malt post)
Region xxx (distillery post)
Country: xxx (distillery post)
Any thoughts howto do this? I'm thinking of using wpdb class, any thoughts on that?