Self Relationship

Question

Hello,I am new to QB, someone helps me out on how to create a self-relationship table in QBI 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------------------------------

DonLarson · Answer

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 LarsonPaasporterWestlake OH------------------------------

Sign up

Login to the community