Thank you for your post.
Your way is just as good as any.
Another option would be to create a value list that is dependent/linked to the related table, and then use the field with a drop-down value list. When you click on the field and the drop-down values appear, just type the first few characters and the first entry for those characters will be highlighted. You can then use the arrow keys to move down to the appropriate record and select it. However, since you may have thousands of records, this would probably not be a viable solution.
Anyone else have some ideas?
That's what I'm doing. I'll import a few thousand records and see what happens. With the DOS RDMS app I use now, the lookups take less than a second, and find the correct record takes about the same amount of time.