Hi jdraw, Thanks for your help.
I have about 350 records - people who DNA match with me and/or my brother. By comparing who matches with whom in my database I can begin to narrow down how we are related. In some cases my matches match with other people who I also match with - it's bringing all those matches together that helps me pinpoint. As I mentioned, I already have good genealogy software on my computer - this is specifically for comparing DNA matches on Ancestry.
I attach a small database with a form and sub form. I've removed most of the records and left 13. I've removed surnames. What I'm trying to achieve is a way of showing the name of my match at the top of the main form frmPersons along with a lot of other information and notes (which I have not included in this example), and in the sub form (datasheet) subfrmLnkDNAandPersons the list of people we both match to.
I want to be able to double-click on a name in the sub form to make the main form "findfirst" the record for the name I double-clicked on. I hope this is clear. It does mean the whole form will refresh, I guess. I don't know if this is a bad idea, but it's sort of how I want it to work. I could open a new form, but if I then double-click on a name in the new form - another form will open, and so on. That's not what I want.
Also, I know this is a bit circular in some ways, but the thing is that these are all the people who match to me one way or another.
tblDNAMatches is my main table and will contain more fileds with all the extra information about each individual
tblPersons is going to be my lookup table for all of my DNA matches.
tblLnkDNAandPersons is a link table with the ID of tblDNAMatches and tblPersons
I hope this is clear and thanks again.
Laura