Hi all,

If I have two tables one for clients and the other with pays, I want to know how can I build a query that lists all the payments of each client.For example, if I put Charles Robertson I want to know all the pays of Charles Robertson and so on.
What controls should I put in my form? Can I use a combobox to the lastname, a textbox to the firstname and a grid for the payments? Should I build a parameterized view or not ?
Please can you send me exactly what can I use for this ?
I built a form with a combo to the lastname, a textbox for the firstname and a grid for payments, is it correct?

tia