I have a query where I have a Parameter to request surname, followed by a second one to request a first name. I would like the second one to offer an alternative of all possible first names. Is this simple to do?
No its not simple to do, not crazy difficult neither if you know how.
What you want is a search form and/or a cascading combobox... have a look around and see how far you get with that come back with any and all questions you have.
The list contains many people with the same surname. The list also contains many people with the same first name.
I want the ability to produce a list with for example everyone with a specific surname eg "Smith" or alternatively everyone with a specific surname eg "Jones" and a specific first name eg "Robert". Smith (or Jones) & Robert both to be selected by the user.