How to make one database output dependent on another?

[taylor84444]

Hey there,

I’m trying to create a custom dashboard for my clients. I offer different services to businesses and want to create description pages for the business’s employees based on what their employer bought; not every business has the same services or the same combination of services.

I have a database of all the services I offer and a database of businesses with booleans of whether or not the business elected to get a certain service.

I have a dynamic page that currently populates a list using all items in my services database, but I want the list to only show what a business has chosen dependent on if the boolean associated with that service in the business database is true or false.

[anhelinak]

You may be interested in connecting your databases with a reference field. You can find more information about it here:

• https://support.wix.com/en/article/about-reference-fields-in-database-collections

• https://support.wix.com/en/article/adding-a-reference-field-to-a-database-collection

• https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931
  By doing so you will be able to create a query that will search through a secondary database. Here is a reference that may be helpful:
  https://www.wix.com/corvid/reference/wix-data.html#queryReferenced