Parent Child Relationship via one table
Hello I am rather new to Quickbase. I anticipate developing a table where users enter our customer company information into. I plan on having a field to designate if the customer company is a pare...
Forum Discussion
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
------------------------------
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
------------------------------
Hi Mike
Thank you for responding.
Essentially when there is a N in the Has Parent it really is a Parent Customer.
Table Customer Has Parent Related Parent Name
Vito Deli N
Subway Hartford CT Y Subway Master Company
Subway Master Company N
Thus on the customer form. I have a text field which lookup of the customer table. 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. 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. I could just have them do this but it will be an issue.
------------------------------
michael malchiodi
------------------------------
Thank you for responding.
Essentially when there is a N in the Has Parent it really is a Parent Customer.
Table Customer Has Parent Related Parent Name
Vito Deli N
Subway Hartford CT Y Subway Master Company
Subway Master Company N
Thus on the customer form. I have a text field which lookup of the customer table. 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. 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. I could just have them do this but it will be an issue.
------------------------------
michael malchiodi
------------------------------