Forum Discussion

LokeshMurali's avatar
LokeshMurali
Qrew Member
5 years ago

Self Relationship

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
------------------------------
Relationships

1 Reply

Sort By
  • DonLarson's avatar
    DonLarson
    Qrew Commander
    5 years ago
    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
    ------------------------------