Good morning!
I have several forms with combo boxes that look up other records and am wondering what sort of issues might be encountered down the road as the number of records increases.
We are realtors in a small town/one county area that has no MLS. Few new houses are built each year and the population tends to be declining. Our population in the county excluding students is around 8500 with 4000 housing units according to the Census and 19% of those are in apartments.
The first example is the Listings Form:
1. 3 combo boxes with Address, ParcelID, HomeID each currently having 669 and less than 200/year added to each at the current rate.
2. A subform which is a continuous form with contacts--currently have 1143 and about 625 will be added during 2012. I would anticipate that in following years it will be the same amount or less that will be added each year since it's increasingly likely that many will be repeat buyers.
The second example would be the Tracking Form with the following combos:
1. Property Name--This looks up all listings. Currently we have 669. Less than 200 will be added each year.
2. Address--Currently we have 669. Less than 200 will be added each year at the current rate. This is the same as Property Name except a different way to approach it. We generally refer/remember by Property Name but there are a few listings that only have the address so we need both.
3. Buyers -- Approx 100 will be added each year at our current rate.
4. Unbound boxes in the header that are part of creating the filter. There are two which duplicate #1 and #2 above.
Thanks!
Connie
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar