Hi Everyone,

Sorry, for the stupid question, I know I've seen the answer somewhere but can't remember what access class or tech help video it was on. I've been back through skimming but to no avail, before having to ask.

I've made a new search form which allows me to search via a customer, rather than the lock they own. The form works fine but if a customer has five locks it shows me that customer five times, this is fine when looking for locks but for customers it is messy how do I only display one entry per customer ID on that form.

Thanks Gary