Wayne <cq*******@volcanomail.comwrote in
news:11**********************@i13g2000prf.googlegr oups.com:
Chuck, my concern is not that the combobox list will be long, but
rather the list of records in the main data table that supplies
the rowsource for the combo is very long, say 200,000 records.
While there may be only 200 unique Customers, the combo box still
has to resolve the 200,000 underlying records, pick out the unique
values and then display them in its list. This takes time,
especially over a LAN and if the user is relying on the
"Autoexpand" property to populate the combo as they type there is
a significant lag. If the underlying data table only has a couple
of thousand records this isn't an issue because everything happens
far more quickly.
I don't know if there is any way around this other than having a
dedicated "Customer" lookup table for the rowsource of the combo
which is the method I use when the underlying list, in this case
Customers, is fairly static. The downside of this is that the
user has to add to this table every time there is a new customer
and this becomes tiresome if the list of customers is growing
rapidly. With the first method, new customers are automatically
added to the list as they are entered into the underlying Customer
Details data table.
Wayne,
This scares me, because if you don't have a customers table, with
one row per customer, storing not just the name, but address, phone,
etc, you are really slowing things down and clogging the lan if you
have that information repeated 1000 times in the Details table.
That's a lot of redundant information that can give you all sorts of
other problems too, Like having to rekey the address every time, or
you look up from a previous record. Say the customer moves. If you
have one place where the address is stored, et's easy to change.
1000, not so easy.
As to adding info to a separate form, that is not necessarily true
that it's tiresome if the design is well planned. The customers form
can automatically pop up if the name isn't found in the combobox,
with that name filled in, ready for the other info, which othrewise
needs to get added on the main form anyways.
Just something to think about.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from
http://www.teranews.com