Select customer records via dropdown box
I have a probably typical beginner question. This is the situation:
I have a customer table and a corresponding customer layout which shows all details for a customer. All records have a unique ID.
I need a drop down box that shows all customer names, narrowed down by what I enter. If I select an entry from the drop down list the corresponding customer details should be displayed on the layout.
I have experimented with all sorts of combinations of relation, second table occurence, value list etc., to no avail.
Can someone please point me to the correct solution for this problem?
Any help will be greatly appreciated.
Thanks in advance