I've a form called Category with two fields; ID + Name.
Another form with several fields also contains the field Category ID. This is the way I want to link both forms.
The link is made by looking up the Name in the Category form. The related ID is then stored in the second form.
How can this be achieved?
Thanks in advance.