I have a Global relationship fromm my account table to my employee table. I have three value lists that use the same relationship, but return different results. Each field uses a different value list. I have a method attached to the onFocus event for each field that changes the global value, altering the value list.
It works sometimes and sometimes it pulls a empty value list, sometimes the scroll bars disappear from the lists, when switching between fields. Especially if I switch to different records records or in and out of designer mode.
This does not make sense to me, unless the global cannot extablish a relationship quick enough, but even if I want you have to keep clicking different fields to get the lists to work. Sometimes the wrong list pops up.
I will post the solution, the form is called TPEAccountRepInfo. Thanks for any Ideas.
why are you using one global for this? Because of this the relation must constanly update itself.
It would be much better to use 2 or more globals for this.
It should go ok ofcourse but altering the valuelist just as you give the list focus is bad practice because then when it wants to show the data is changed at the same time.
Well, I used on global so I only had to create one relationship and I did not realize the it was a bad practice, I did not know it would effect performance. I will try using serveral globals. As far as seeing my solution, it is posted. It still seems like the value list show not behave with such inconsistancy.
I created the aditional global relationships and called then via an onshow event. Everything wroks fine, but I just don’t like creating more global relationships then needed.