• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

Table Relationships for Linked Tables

I have 2 tables that have a one to many relationship set up in the backend DB. They are also set to enforce referential integrity, cascade update related fields, and cascade delete related records. When I open the main table in my frontend in datasheet view I do not see the little plus signs to expand the subdatasheets for the linked table. I only see this in the backend DB. Is the plus sign not used or not able to be used in the linked tables in my frontend?
0
Lawrence Salvucci
Asked:
Lawrence Salvucci
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Relationships are only honored within a single DB container.

If you want auto join in queries and the sub datasheet feature, you can have the relationships in the FE as well (either create or import them), but they won't be enforced.

Jim.
0
 
Lawrence SalvucciInformation Technology ManagerAuthor Commented:
I figured that's what it was but just wanted to double-check. I'll just create a query with both tables in it. Thank you for the quick response. Appreciate it!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now