Same-Table Relationship
I have a complex multi-table App used as a Project Management System that supports our End-to-End process from Intake, Governance, Prioritization, Resource Assignments, Status Updates, Multiple Releas...
Forum Discussion
Marcelo - A bit more complex than your relationship.
Project B may be a Big brother and have 30 Sibling projects associated to it
Project D may be a Big brother with 5 sibling projects associated to it.
Project H may be uniquely funded with 0 siblings associated to it (other than itself)
Conceptually we have it mapped.
Tactically we are not sure HOW to relate a sibling project to its Big Brother via a Same-Table relationship. We envision this as a dynamic drop down list of projects that are already approved to be approved as a funding source.
------------------------------
Annetta Coleman
------------------------------
It occurs to me to create a flag to know if a project can be big brother and a field to know who is the big brother of a sibling, create a report filtering the projects marked as big brother, put the result of that report in a ComboBox ( second field ) and so when you create a sibling you can associate it with one of the possible big brothers.
Hi Marcelo -
Yes, we already have the flag to determine if the Project is Funded (and thus eligible to be a big brother) and also a field to know who the Big Brother is (for projects that are not uniquely funded). We envision that the field that identifies the Big Brother project is a drop down. I do not see reference to ComboBox in QB help. Can you provide a link to an article? Is this a Report Link?
------------------------------
Annetta Coleman
------------------------------- I apologize, I was in another project and I have digressed in different programming languages.... It does not allow filtering by the flag field that defines if it can be a big brother, to achieve this you have to have at least one table where only the possible big brother.
The functionality I desire should be available via a "Same-Table" Relationship. I just cannot find any articles that discuss this feature.
Hoping others in the community can respond if you have guidance to offer. I will also open a ticket with QB support.
------------------------------
Annetta Coleman
------------------------------
