Discussions

Expand all | Collapse all

Self Relationship

  • 1.  Self Relationship

    Posted 12-21-2019 17:40
    Hello,
    I am new to QB, someone helps me out on how to create a self-relationship table in QB
    I need to create a table in which one record in that table may be related to another record in the same table. To achieve this i need to create a self-relationship with in the same table. Thanks in advance!!

    ------------------------------
    Lokesh Murali
    ------------------------------


  • 2.  RE: Self Relationship

    Posted 12-22-2019 19:12
    Lokesh,

    Creating a Table to Table for the same Table is very easy.  Select the same Table when you go through the connection process.


    Are you sure you need to relate the Table to itself?    I find this to be a rarely required in DB architecture.   What is the business case you are trying to solve?  Might there be another way to get to the objective without a recursive relationship?



    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------