---
title: "Using Data Mesh and Virtual Foreign Keys | DreamFactory"
description: "How to impose relationships between tables that have none — whether they sit in the same database or entirely different ones — and then retrieve the related…"
url: "https://www.dreamfactory.com/videos/data-mesh-virtual-foreign-keys"
---

[Home](https://www.dreamfactory.com/) › [Videos](https://www.dreamfactory.com/videos) › Using Data Mesh and Virtual Foreign Keys

# Using Data Mesh and Virtual Foreign Keys

Tutorial·12 February 2016·7 min 24 sec

How to impose relationships between tables that have none — whether they sit in the same database or entirely different ones — and then retrieve the related records in a single API call. The conceptual foundation for DreamFactory's data mesh capability.

**Recorded in 2016.** The concepts still apply, but the interface shown predates the current DreamFactory release. Some steps may differ in the current release.

## What you’ll learn

* Relating unrelated tables within or across databases
* Retrieving related records in one API call
* The foundation of the data mesh approach

[Book a Demo](https://www.dreamfactory.com/demo)[More on our YouTube channel](https://www.youtube.com/@DreamfactoryAPI)

## More videos

* [Connecting to a Remote Web Service](https://www.dreamfactory.com/videos/connect-remote-web-service)
* [Admin Console: the Config Tab](https://www.dreamfactory.com/videos/admin-console-config-tab)
* [Admin Console: the API Docs Tab](https://www.dreamfactory.com/videos/admin-console-api-docs-tab)
* [Admin Console: the Scripts Tab](https://www.dreamfactory.com/videos/admin-console-scripts-tab)

[Browse all videos ›](https://www.dreamfactory.com/videos)

Video: https://www.youtube.com/watch?v=bmZcAI2HdcM