I followed the instructions carefully on how to connect two datasets
I added a dataset (Workout Series) to a page
I added a second dataset (Workout Reviews) to the same page
When I select a Manage Dataset and try to access the down arrow next to Value, there is no down arrow. I cannot seem to select which values the two datasets should share.
Each dataset has a common field, Series, which I would like to link to display data, but the option is not available. How do I get the option available?
What I’m trying to achieve is that on this page:
https://www.seanarenas.com/WorkoutSeries/PiYo
It will only display workouts which match the Series that is specified on the page.
How would I do this correctly?
Hi Sean,
At the moment joining and showing data from two separate dataset is not supported
The good news is that we are working on a feature that will allow it.
As an alternative you can add a separate table to display data from your other dataset.
Hello,
I have access to the Beta features and am a Premium user, and this is a feature listed in your documentation. How would I go about implementing this?
Ido Inbar, what I’m trying to do is list Workouts in a particular Workout Series on that Workout Series page.
Example:
Workout Series: Muscle Sculpting
Muscle Sculpting Workouts: Upper Body, Lower Body, Abs/Core
There will be other Workout Series with other Workouts in them. When someone views the page of a particular Workout Series, I want ONLY the Workouts that are tagged with that series to be displayed on the page. How would I do this? Where is that association specified?
Hi Ido, still trying to get support on this. What are the proper steps for me to take to get support?
Ido, this is no longer a Beta feature and is available to everyone. Can I get support on this now, please?
Hello Sean,
I apologize for our delayed response.
The reference fields feature was just released. It allows you to connect one collection to another collection You can read more about it here
Best regards,
Hello , I am facing a weird problem ,
I am connecting a simple text to the database via a dataSet and the problem is that it’s working on the Editor when i type to see the website and it’s not the case for the online website !!!
I ve also writen some code and it’s the same case !
Sincerely,
Hi nef_kais, did you sync the data from the sandbox dataset to the live data?
Yes , I’ve made it ! let me send you a screenshot
That’s how you connect the object to the dataset on the page, which connects to the database. But … if you go to the Wix Website Editor, under Database on the left, go to the data collection with your data. At the top of the screen, there’s a Sync button. Select it and click Copy All Items to Live.
Then Publish.
Then Refresh the page (or try a different browser just in case it’s a caching issue).
It works yahhh !!! thank you 
No problem - just remember to re-sync the data every time you add or change anything in the database. Might want to read up on the documentation for the syncing to get a more clear understanding.
Help! I have spent two days trying to solve this problem and I’m sure it’s going to be something simple in the end but right now I need to get it done so any help would be appreciated. I have created a page like the recipe example in your tutorial but mine contains a dropdown list and a gallery. The dropdown list is now working and displaying the list from one dataset but the gallery will not display anything at all. I have filtered the second dataset with the field from the main dataset which populates the dropdown list. I have even used reference fields to connect the two databases and I have synced the databases. Neither in preview or published will the gallery display anything. Any ideas?
