Forms

[Liat]

Hello,

I have a form for a table that contains fields for name,
ID and more details that are not relevant to the question.

I have another table of name and ID.

I would like that if the user chooses the name field in
the form and chooses a name out of it, the relevant ID
will be updated in the ID field that in the form
according to the name-ID table. And the opposites, if the
user chooses the ID field and chooses an ID from it, the
right name will appear in the name field of the form.

Thanks a lot,
Liat