We need some names here, in order to be clear. So let's say your participants are in a People table, and the field you have used to select the other person is called Selection. Assuming you have defined a self-join relationship of the People table as:
People::Selected = People 2::Name
you can now Go to Related Record [ From table: People 2 ; Using layout: <Current layout> ]
Note: It's not good practice to use names for relationships - you should use unique ID's instead.
Thank you for clerifying what I mean :-)
You got it all right and that is exactly what i have done, and yet it still doesn't work, I'm wondering whether I have missed somthing in the script or wether there is a problem with the value list in the field Selected (as you calle it)...?
I don't think the value list plays a part in this; as long as you do have a value in the Selected field, it doesn't matter how it got there. What exactly does "doesn't work" mean?
Now it works!!!
I found out that I forgot to put an arrow in "Allow creation of records in this tablevia this relationship" for both tables. So now it is good!
Thanks for all your help!
I found out that I forgot to put an arrow in "Allow creation of records in this tablevia this relationship" for both tables.
I don't see how that would help with the problem you have described. In fact, I don't think it's a good idea to enable those options for this relationship.
I don't why - but after i did that it worked.. so..
Just because something works doesn't mean it works properly. And there is a difference between whether something will work and whether something is a good idea. You should step back now and try to understand what works, why it works and whether you have it properly configured.
If you do not, then you will continue to build your solution and, after putting in another weeks' worth of work, you will discover you connected it improperly and you will have to undo all of your work and start that portion again. I call it unraveling your knitting and it is a waste of time. And if you ignore 'why it seemed to work even if not suggested and you have no idea why' then you will not learn for the next time you need something similar.
UPDATE: If you want to be sure it is a good base from which to continue building, upload the file to a free file sharing site and ask for input on it.