>>A view can help with displaying (and editing) information from another table, but I do not think it addresses the problem of presenting a dropdown style list for foreign key entry. I think I'll need to create my own control that uses a grid for the drop down list since combo boxes are too slow for large files.
>
>well, using a grid is a good solution on many occasions
>but I am not sure u need it here u just have to update the combobox whenever u change a record (e.g. REQUERY the view) so that it will display the new related info
>
>Arnon

Arnon -
Thank you for your help. I'll consider how views may help. However, Combo boxes are always slow when the rowsource is a table, alias, or view with thousands of records. I found a knowledge base article that directly address my problem (Q155015 - "How to build a custom Combo Box"). The article confirms the limitations on Combo box application.

Duke