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

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