I have two different data models but they pertain some of the same fields. I was wondering if there is a way to merge them together since they have the same fields? Or if I should just relate them?
I tried a couple of relations but haven't deployed to see if it works.
To display a join of two related dbs, add a page with one of the two dbsas the default data source, then add a table.
When you are choosing from the tables datasources there should be something like "Tablename(create)" and "Tablename(relation)". That's where you'll get the joined table.