NeoDBpro and dbpDefineRelationship.
Quote from m.burdess on March 15, 2024, 1:17 pmI have used "dbpDefineRelationship" within my project, but can not find a work around, to link two or more record from the same table.
The project is Family History, and I am able to create a digital index Card. This shows the person and his or her Father/ Mother, and marriage.
The problem is Showing the Children, as this information comes from the same table as the Father / Mother.
dbpDefineRelationship "GOON" "FamilyIndex" "AFN_B" "GRO" "AFN" ""The table "FamilyIndex" has AFN_Child1 for the first child and for each child I just change the number at the end.
This information all come from the table "GRO", the record number is shown within the variables, but does not show on the index card.
Is their a way to rename the information from the record ( [GOON.GRO.Givn] ), making it show up on the index card?
I have used "dbpDefineRelationship" within my project, but can not find a work around, to link two or more record from the same table.
The project is Family History, and I am able to create a digital index Card. This shows the person and his or her Father/ Mother, and marriage.
The problem is Showing the Children, as this information comes from the same table as the Father / Mother.
dbpDefineRelationship "GOON" "FamilyIndex" "AFN_B" "GRO" "AFN" ""
The table "FamilyIndex" has AFN_Child1 for the first child and for each child I just change the number at the end.
This information all come from the table "GRO", the record number is shown within the variables, but does not show on the index card.
Is their a way to rename the information from the record ( [GOON.GRO.Givn] ), making it show up on the index card?
Quote from Gaev on March 15, 2024, 6:05 pm@m-burdess
I don't have a working solution, but when I did a Google search like so ...
sql relate records in the same table
... one of the matching responses was ...
How do I join rows in the same table in SQL?
The self-join syntax involves aliasing the table references and joining them together, just like you would join two different tables. SELECT t1. column1, t2. Column: You select the columns you want from each instance of the table.
Mastering Self Joins in SQL: The Ultimate Guide - Simplilearn.com
So, the solution might lie in you defining an Alias for your Table named FamilyIndex and then specifying the Alias name for the Detail table name.
Hope this helps.
I don't have a working solution, but when I did a Google search like so ...
sql relate records in the same table
... one of the matching responses was ...
How do I join rows in the same table in SQL?
The self-join syntax involves aliasing the table references and joining them together, just like you would join two different tables. SELECT t1. column1, t2. Column: You select the columns you want from each instance of the table.
Mastering Self Joins in SQL: The Ultimate Guide - Simplilearn.com
So, the solution might lie in you defining an Alias for your Table named FamilyIndex and then specifying the Alias name for the Detail table name.
Hope this helps.