Cross-app relationship

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have two tables in different apps. Events and Employees. I would like to set a cross-app relationship between Events (parent) and Employees (child). When I create the relationship in "employees" table, I cannot see any field created in "events" table. Any way to solve this?
Photo of Pablo

Pablo

  • 40 Points

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Before we get into trying to diagnose the problem with that relationship, we should discuss what your goal is. It is unlikely that you need a simple relationship where one event has many employees.

It is more likely that one event has many employee attendees, and also one employee has many employee attendees. In other words you probably have a situation where one event has many employees attending but also one employee overtime may attend any events. Is that your situation?

If that is the case then what you have is a classic many to many relationship. So what you will need is to create a middle table or also called a joint table which is called say event attendees.

One event will have many event attendees, and one employee will have many event attendees.