Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select filed from 2 tables
Message
From
09/03/2006 09:05:58
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Select filed from 2 tables
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01102730
Message ID:
01102730
Views:
54
hi all,

any idea ,help

vi myform how i can choice 2 fields from 2 tables via 2 textbox,
the 2 fields did not have the same name,

i do that as programmer via this code under,

i need to let the user choise the 2 fieled&&2 fields have same type(numaric)
CLOSE all
USE bill in 0
USE contact in 0

replace IN contact ;
   FOR cc==LOOKUP(bill.cc,cc,bill.cc) AND NOT EOF('bill') ;
   val with VAL(bill.bill_value)
i need to do that via my form as
 thisform.text1.value=bill.field&& any table and any field 
 thisform.text2.value=contact.field && any table and any field
Next
Reply
Map
View

Click here to load this message in the networking platform