Ideas needed for displaying a client list

[tunage]

Hi, im developing a database to record orders made by clients. Its going fine, but im struggling over how i should display a list of clients for the user to choose from to assign to an order.

Ideally i would like a MS Access type 'list-box', which would display their forename, surname and organisation and they could select the relevant client from that.

Ive tried using a select box, but it just looks a mess with the name and organisation of each client being different sizes. Ive also tried having a page with the clients listed to select them, but the difficulty with that option is that if it spans over several pages, and when i use a coulmn sort, its a pain getting back to the order form.

So, would I be best having a 'pop-up' that has a list of all the clients, they click on a client and it inserts them into the order form, or just have the order form navigate to another page to select them.

Any ideas or example you know of?

thanks 🙂

[bastien]

use a cookie the first time the order is set up or if the cookie is not present then set a cookie with the client ID number

have the script then read the cookie and if present take the cookie value and find the client info and present that back in the form...

if no cookie is present and they are a previous user, then show the list, let them pick from a link and then do the same thing...but cookie them for the next time