It is all fantastic and super while the linked field has a few dozen values. Then dropdown is practical, even checkboxes might be useful then. But If I have a few hundred items in the linked field the dropdown is the worst of all choices. Why not just a simple number or text field? I could even write my own verification code! Even all country list is in nundreds. Same for currencies. Why not let the user just enter EUR or USD? Why they need to scroll?

And you really should allow multiple columns in the dropdown, just like Access does it. One would be the bound column (country ID, for example) and the other would be for the user (country name, for example). To a certain degree filling forms through navigation can circumvent the problem. But if I need three or four linked fields from different tables on the same form then that is not possible. If I have an invoice, for example. I want to fill a field of the Service Provider ID. I want to use ID, not the name, as company names change. Not possible. And XXXXXXXXXXXXXXXXXXXXXXXXXXX wil not mean much to.

I know, there is a workaround. I can add another dropdown box and then add code On Add or Edit that sets the Provider ID. Not sexy...