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?
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.