Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

I'm trying to create a relationship between 2 apps

So I have 2 apps, The main one with an employee table and a side one with a out of office table that states when someone is expected to be out of the office and who is going to temporarily fill in for them.

I would like to connect both of them to have a field pop-up saying who is going to be the temporary fill in for employee's who out of office. It seems so easy, but I can't seem to figure it out.

I tried making a relationship from the employee to the out of office table and it seemed to give me the information I wanted, but it broke the employee table. I tried the other way around, but that only allowed me to create summary fields for the employee table. 
Relationships
Tables and fields
Tips and tricks
  • KingslySamuel's avatar
    KingslySamuel
    Qrew Cadet
    7 years ago
    Are these two tables or two apps? If two apps, is there any connection (like a key field) common between the two apps? In other words, the employee name should be the same (and linked) between the two apps and then you can achieve what you are trying in the out of office app.
  • KingslySamuel's avatar
    KingslySamuel
    Qrew Cadet
    7 years ago
    Hmmm ... it should work. It looks like you have done everything right. What is the breaking in the employee app? Did you try doing it in the out of the office app?
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    When I did it through the employee app, it only allowed me to say it's one out of office to many employees, when I needed it the other way around. Which I think in turn, made the employee table rely on the out of office table in their respective apps. When I do it from the out of office app, the relationship is correct, one employee have many out of office, but it only allows for summary fields to be created for the employee app.