I want to duplicate the logic and functionality of a look up like the CRM look up field uses. The related Look Up field has drop down but when there are lots of records, that does not work.
Have table of records that need to be related from the parent form. Only one record needs to be selected and shown on the parent form. I've tried subforms but can't get it right since the subform is only for the selection not the display in the way it is used for the CRM data relationships
Can anyone point me to any information, as I've tried to find a technique but have yet to find one exactly as needed.
Thanks..