>> Now in such a case what should we use that allowsthe user to quickly enter
>> the products?Sonali
>Sonali,
>
>I would create a catagorization of products that allowed multilevel selection. I would also give the user a textbox into which they could type the product ID they wanted (in case they knew I and didn't want to fiddle around with searching). The form would allow the user to select from each level and then populate the next level until the user had chosen the actual product.
>
>If this was a point of sale system I would immediately move to bar coding for the data entry.

I am trying something similar. I have an agency combobox and a contact combobox. The agency requeries the contact when it changes. The parent record holds a pointer to the agency and a pointer to the contact. The interactive part works OK.

When I display a record which points to contact #5 of the agency and then display a record which has an agency w/ only 2 contacts, I get a record out of range error when the contact refreshes. Another thing that happens is that sometimes the contact combo displays the contact when a different parent is displayed, sometimes it is blank until you tab through it twice. (or tab, shift-tab).

Have you run into this before?