Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Quick Base University
Skip main navigation (Press Enter).
on this day
between these dates
Cross-app relationship | Discussions
Back to discussions
sort by most recent
sort by thread
I have two tables in different apps. Events and Employees. I would like to set a cross-app relations...
Before we get into trying to diagnose the problem with that relationship, we should discuss what yo...
Posted 05-20-2017 11:43
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?
RE: Cross-app relationship
Posted 05-20-2017 12:08
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.
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Skip Navigation Links
Terms and Conditions
Powered by Higher Logic