Discussions

Expand all | Collapse all

Relate two tables with a Related field that exists on both tables..

  • 1.  Relate two tables with a Related field that exists on both tables..

    Posted 02-05-2018 19:22
    Relate two tables (Permits and Poles) with a Related field (ApplName) that exists on both tables.. This Related field (ApplName) comes from a third table (ApplNames) which both tables are related to. This Related field is not a Key field on either of the two tables but is the Key Field of the 3rd table.


  • 2.  RE: Relate two tables with a Related field that exists on both tables..

    Posted 02-05-2018 19:28
    If you just want to show an embedded report of each�s others �related records� then just create a report link field without a relationship.


    A report link field just needs two fields to match in any two tables. Even with no relationship.


  • 3.  RE: Relate two tables with a Related field that exists on both tables..

    Posted 02-05-2018 20:45
    I�m trying to establish relationships workaround with one as child of the other so I can import and match records routinely and all other benefits of related tables.


  • 4.  RE: Relate two tables with a Related field that exists on both tables..

    Posted 02-05-2018 20:56
    Quick Base only supports 1 Key field per table. Can you change the Key field of one or both of the tables to [applname]


  • 5.  RE: Relate two tables with a Related field that exists on both tables..

    Posted 02-05-2018 21:23
    Interesting. I will try it and let you know. I seem to be going in circles and don�t know if I have enough or too many relationships. I need everything to be visible everywhere so wonder if my data model has too many crossing lines. Like string art. Thanks.


  • 6.  RE: Relate two tables with a Related field that exists on both tables..

    Posted 02-07-2018 03:34
    Alas, couldn't make it a Key field because it's not Unique. Thanks for the suggestion.


  • 7.  RE: Relate two tables with a Related field that exists on both tables..

    Top
    Contributor
    Posted 02-07-2018 14:14
    Hi Ruby,

    do you specifically need the full functionality of a relationship to allow you to use lookup fields and summary fields for your data or are you simply looking to make it possible for you to view records from one table that have a matching value on something like an embedded report? For example Show all Permits on my Poles with the same ApplName field value in an embedded report on the form?