Considering that the Products collection cannot be expanded to include new fields (say for example, "Short Description"), I thought I would put additional product specific info into another database and display it on the page.
For example, the standard product detail page shows things like Name, Description, and Price. These all come from the Products database. I want to define a Short Description for each product and show that on the page instead of Description.
There's so much information in the forum and the Wix Code site that I haven't come across a sample of this but it seems like it should be a fairly common need. I'm hoping the problem is me not finding the existing answer rather than the answer not being out there at all!
I tried adding the dataset for the Products database and my own database to a dynamic page (that is based on the Products database) but it doesn't work. I thought there might be an automatic connection between the Products database and my database considering that my database has a reference column back to the Products database.
I hope I'm making sense with this! :) Can someone point me in the right direction?