Parent Child Relationship via one table

Question

Hello I am rather new to Quickbase.I anticipate developing a table where users enter our customer company information into.&nbsp; I plan on having a field to designate if the customer company is a parent or a child company.&nbsp; This will be a True False field.&nbsp; True indicates a child company and False indicates a parent company.&nbsp; To designate what parent/company the child/company rolls up to I am thinking of a drop down field which pulls the distinct values of this table (where the roll up designation is false(Parents))&nbsp; Thus I plan on using one table for parent and the child and designate between parent and child by this field.&nbsp;&nbsp;Reason for not using classic parent child relationship(two tables)If I use the classic parent child relationship I would have two tables and in most cases the parent information would be exactly the same as the child.&nbsp; Fully 95% of our customers do not rollup into another company.&nbsp; I am thinking in this situation the users would have to create a parent company for every child when they are exactly the same in order for this to work(duplicating the data entry).&nbsp;&nbsp;Is there a better way to do this?&nbsp; In addition I am trying to avoid pipeline logic.------------------------------michael malchiodi------------------------------

miketamoush · Answer

Can you give an example?Are you saying your table is say, 'Customer Information.' Perhaps the Customer is Bob's T-Shirts.Bob's T-shirts may be a parent to another company in your system, and maybe a child to another customer in your system and you want to acknowledge this?------------------------------Mike Tamoush------------------------------

michaelmalchiod · Answer

Hi Mike&nbsp;Thank you for responding.Essentially when there is a N in the Has Parent it really is a Parent Customer.Table Customer&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Has Parent&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Related Parent NameVito Deli&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NSubway Hartford CT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Subway Master Company&nbsp; &nbsp;&nbsp;Subway Master Company&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; N&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Thus on the customer form.&nbsp; I have a text field which lookup of the customer table.&nbsp; The problem I am facing is that I have not been able to figure out how to limit that text field lookup to only pull those records where Has Parent is N.&nbsp; I need this or the users will be choosing Children as the Parent.I am trying to keep the user from having to enter Vitos Deli and all the information into the a parent table and a child table to keep the relationship valid.&nbsp; I could just have them do this but it will be an issue.------------------------------michael malchiodi------------------------------

Forum Discussion

Parent Child Relationship via one table

2 Replies