I would like to create some reports based on relationship. For example a list of all my first cousins one removed. The current Kinship list includes that group, but i would like to be able to add some additional columns other than just name and relationship. Don’t think there is any way to do this in version 11.
This would be intermediate plus level done via sqlite –do you want to create a Group of first cousin 1x removed? The concept is relatively straightfoward.– would need to be done outside of RM. If RM had access to RELATE1 & RELATE2 values or the relationship desc inside of it would be easy
Unfortunately, I am not well versed in using sqlite. Also, don’t know where to find RELATE1 and RELATE2 values.
they are unfortunately not accessible within the RM UI (program) – which is why Sqlite would be needed. They are two columns in the PersonTable.
if you developed a sqlite script to product say a group or view – it would need to be refreshed each time you need it so it was updated. (also the SetRelationship would need to be updated first). RM does not support or recommend using sqlite and should be left to user who understand what they are doing and potential consequences. Using read only queries should be safe.
