Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Pennsylvania - United States
 Yuri Rubinov
 To: Travis Pick
  Where is Travis Pick?
 Travis Pick
Subject: RE: set filter to ....
Thread ID: 33804 Message ID: 33809 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: General VFP Topics
Date: Wednesday, December 03, 2003 9:10:11 PM         

What do you mean, "link the combo box to the vendorname field in the vendors table"?
If combobox contains the list of available entries from entry table, and you select the value in the combobox, then you may set filter like:

sele vendors table
lccom="set filter to vendorname=["+thisform.combobox.value+"]"
& lccom

> Hi there gang, here is my situation.
> I am working with two tables in this instance, a vendors table and an entry table. I have say 20 vendors in the vendors table, but only 5 of them bringing loads which are stored in the entry table.
> The two tables are linked on a vendorID number.
> I am creating an interface screen for users who won't know which vendor ID corresponds to which vendor. On this screen is a combo box which is to have a list of all vendor names that are in the entry table. So I want to set a filter on the vendors table, and link the combo box to the vendorname field in the vendors table.
> How would I set this filter, or is there another way I can go about this.
> Thanks in Advance...
> Travis Pick


set filter to .... Posted by Travis Pick @ 12/3/2003 8:23:51 PM
RE: set filter to .... Posted by Yuri Rubinov @ 12/3/2003 9:10:11 PM
RE: set filter to .... Posted by Geoff Franklin @ 12/5/2003 6:36:36 PM