Can you have multiple databases in ONE site?

Here’s what I’m hoping to do:

  1. I have several sections on the home page. For each section, I’d like to have a separate database.
  2. However, I’d like to be able to have an “index” page which allows searching for key topics across all databases.
    For example: It’s a health site that will have a breaking news section, plus sections for nutrition, recipes, weight-loss, etc. I’d like to populate each section from separate databases for convenience (and control over how many news items are displayed). THEN, I’d like to have a searchable archive page so readers can search past articles for their health issues. This archive would need to extract info from all databases.

One more annoyance: I know you can add multiple databases with the editor BUT only one seems to show when I try to link an element!! See pics below…

Editor shows 2 databases in site structure…


But just one shows in editor workspace and drop-downs for linking.


Why???

If i understood it right, the problem is that you only have 1 dataset. After makeing a collection, you need to connect it to a dataset, and it looks like you only did that to the UNCENSORED collection. To add a dataset to the Topsides collection, look at the image i am attaching. Click on Dataset, and follow the instructions. Then you will have two datasets, and you will be able to connect data to both of your collections.