Some help with Associations Needed...
I am building a database of historical information. I want to be able to search for associations between people (a max of 3). So, I created one master list of individuals "individual data" and 3 different lists, individual1, individual2, individual3...as you can see from the image.
The only problem is that when I choose the first name, the other two boxes copy that name. I changed the second box to give me a list of names from individual 2, and the third from individual 3.
It's not working.
Not sure what to do...thanks for any help.