how to update lookup fields automatically
Posted: Thu 17 Aug 2006 22:45
I am experiencing the following problem:
1. I am inputing data into a customer form
2. One of the fields is a Tdblookupfield (state/province), which is fed by a state/province table. At this point I notice that I need to complete the list of items, by going to the State/Province form.
3. Lucky me!, I have a button nearby to access that form, directly.
4. I go to it, insert and post the new record and return to the main form.
5. When I drop down the dblookupcombobox, I canĀ“t see the new State/Province.
6. I have to leave the application and reenter it in order to refresh the dblookupcombobox
7. I used to use Paradox and the refreshing was automatic.
8. How come the same does not work with SDAC?
9. Is there a way to work around or solve this situation?
Thanks.
1. I am inputing data into a customer form
2. One of the fields is a Tdblookupfield (state/province), which is fed by a state/province table. At this point I notice that I need to complete the list of items, by going to the State/Province form.
3. Lucky me!, I have a button nearby to access that form, directly.
4. I go to it, insert and post the new record and return to the main form.
5. When I drop down the dblookupcombobox, I canĀ“t see the new State/Province.
6. I have to leave the application and reenter it in order to refresh the dblookupcombobox
7. I used to use Paradox and the refreshing was automatic.
8. How come the same does not work with SDAC?
9. Is there a way to work around or solve this situation?
Thanks.