Quick question I hope. I have a layout which shows customer details. To make it quicker to find a different customer I want to have a drop down box on the layout which shows all customers and another which shows customer number. I tried putting a another copy of the field to do this but there's an obvious difficulty.
If I'm looking at Joe Bloggs record and his customer number is 0001 I can see all his details. I want to go to Fred Smith so I drop the extra box I created and I find Fred Smith. It does go to the Fred Smith record but unfortunately it keeps his customer record as 0001 rather than showing what it should be.
Any suggestions please?