select related record through portal

[laddaa]

Hi,

in short I'm trying to do the following:

-there's a Table "Letters"

-and a Table "People"

-In the layout for Letters I want to select the recipient through clicking on a line of a portal.

So far, I'm stuck with two things:

1st Issue:

If I set the relationship: Letter::kf_ID_recipient = People::k_ID, then the portal is empty, but the assignment of one recipient to one letter

works as expected.

If I set the relationship: Letter::kf_ID_recipient X People::k_ID, then the portal is populated correctly (I can do nice searches/filtering), but

I don't see how the assignment would possibly work then.

2nd Issue:

how do I actually assign a record by clicking on it? I tried some

Button Setups and Script triggers (all very much fruitless attempts)

What do you think. Will I be getting anywhere ?

Thank you for looking at my problem.

[efen]

Like the attached?

letter.zip

[laddaa]

Yes! That's so neat! Thank you! I will try to implement your solution to my file as soon as I get a chance!

(I'll try to change it so, the click assigns the person to the current letter, not a new letter, but otherwise

it's exactly what I was trying to do!)