Things are moving along with the Genealogy database. I have found some solutions to the two issues I originally had. I'll post what I have done so far, and what issues remain.
1) Thanks to Ender's suggestion, I created a separate Table called Family. I had to create multiple occurences of this table to handle the various relationships matching individuals as Husband, Wife, and Child(ren). I used three seperate IDs in Family (husbandID and wifeID matched up with individual IDs; a familyID in an individual record matches with a marriageID in the Famiy Table).
I created scripted buttons to add or connect to Husband, Wife or Child records, which would create a new individual with the appropriate links made.
*The hardest part has been scripting the ability to link fields to the related records. Go to Related Record only seems to work over the main Occurence which did not work for all fields. I got around this through a roundabout way by copying the husbandID, opening the individual layout in a new window and performing a find via the ID. This seems to work for now, but I am hoping to find a proper way of doing this.
*The other issue is that from an individual record, I have been unable to create a portal that would show the related spouses. I have to create two portals one for husband and one for wives. Is there a way to have the portal recognize the gender of the individual and modify the portal settings dynamically to show the corresponding spouses?
2) The cross-over portal is now working. I accomplished this by setting up a referenceID in the Sources table. I then setup the field as a Checkbox set with the "Include Other..." option set. The value list was setup to use values from the ID field in the main table, with "include related values" checked.
This then adds checkboxes only for those records which are related. The portal on the individual side shows all Source records with a corresponding checked box. While the portal on the Source side shows all individuals related to the check boxes.
*My challenge now is to create buttons to handle the addition of sources and connection of individual to existing sources. I'll need to figure out a way to get the script to dynamically add records to the related value list.
Once these are done, the source table will be duplicated as a Events table.
My next steps include:
• Creating a media table and linking to existing tables.
• Cleaning up the interfaces and linking them into a clean user environment.
• Build a front end window that uses an index of all records to provide a jumping off point.
• Begin building reports.
If there is anyone out there who would like to try it out in the near future, let me know and we can work something out.
Thanks,
Craig
PS - Brent, if you could forward me the GEDCOM utility, I'd like to try and incorporate that bidirectionally in the future. Thanks.
