Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Displaying a lookup field
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00232130
Message ID:
00232319
Views:
16
In the init and refresh of the textbox you can put lookup code such as the following.
lnprojid = maintable.projid
select name from projtable where projid = lnprojid into cursor cProjLookup
this.value = cProjLookup.name
The counts on a refresh of the form taking place.

>I'm paging through a form using a NEXT button and I'd like to show "lookup values" from another table which get refreshed each time I hit a next button. For example, my form has project number stored in the main table of the form, and I'd like to display in the project name in a read-only field.
>
>Among other things, I've tried:
>1. seeking the correct record in the lookup table
>2. writing the value of the name into the textbox.value
>3. refreshing the form
>
>This doesn't seem to update the textbox at all...although logically it should work. I've also tried poking at the refresh() method of the textbox.... that didn't seem to work either. So....I'm thrashing!
>
>Anyone have a reasonable way to do this?
>
>The tables are buffered, if that makes any difference.
>The tables are *not* related...i.e. there is no permanent relation setup between the table.
>
>Many thanks.
>
>--- Larry
Previous
Reply
Map
View

Click here to load this message in the networking platform