record selection: is this ok? 1

[mmaz]

Hello,

My application enables users to maintain(insert, update & delete) a list of companies.

A combobox lists all the company names, and when the user selects a company, its full profile is displayed.

This is how I did it, but I don't know if there's a better way: Fill my combobox from recordset with only companyId and companyName, and when the user selects a new company, query the database to get the full profile.

Is this a good way, or should I use the proxy pattern or maybe a disconnected ResultSet?

Thanks,

Marie

 

[DonQuichote]

Sounds like the right way to do it. I'd even see this as a kind of proxy pattern: The entries in the combobox act as proxy for the full objects.

The need for the full proxy pattern is a bit dependent on the programming language. If you can bind a combobox directly to a database query (which is a common approach in Microsoft environments), it would be a lot of extra work to generate all the proxy objects.

Best regards