Discussions

Expand all | Collapse all

I'm trying to create a relationship between 2 apps

  • 1.  I'm trying to create a relationship between 2 apps

    Top
    Contributor
    Posted 03-27-2019 17:03
    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. 


  • 2.  RE: I'm trying to create a relationship between 2 apps

    Posted 03-27-2019 17:17
    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.


  • 3.  RE: I'm trying to create a relationship between 2 apps

    Top
    Contributor
    Posted 03-27-2019 17:53
    Two apps and The employee name are linked.


  • 4.  RE: I'm trying to create a relationship between 2 apps

    Posted 03-27-2019 17:59
    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?


  • 5.  RE: I'm trying to create a relationship between 2 apps

    Top
    Contributor
    Posted 03-27-2019 19:06
    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.