Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select after choose 2 fields
Message
 
To
12/03/2000 17:20:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00344762
Message ID:
00344773
Views:
22
>Hi, all
>
>I want to create a view grid based, after in my form input two fields, Suplier.id and ref.id. I want to join in this view all suplier.id references but i want to go to my master db get the ref.id name(description).
>
>Thank's in Advance
>
>Joao Batista
>(Beginner VFP6)

Hi Joao,
Are your Suplier.id and ref.id in 2 different tables?
Do you mean you want also the description for your ref.id which is in yet another table?

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform