Record ID


This Discussion is public



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.


A little info... The category would have to be unique, otherwise the system would never know which ID to grab.

Try cascading the data like this -

Discussion closed.