I have the same problem.
When i want add record from frmJournal.
My task:
1. Must enter name which only presented in table Pupils. (without useing list, only textbox).
So, when i write pupil name into field, they automatical set field PupilID, for normally save record.