Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting filter conditions based on records in a table
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Setting filter conditions based on records in a table
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01074912
Message ID:
01074912
Views:
42
I have a users table which stores the user number and other conditions. The table may look like:
Userno       Attribute         Value
-------------------------------------
3            Country           Morocco
3            Country           Ukraine
3            Factory           New Line
3            Factory           Woven Mod
3            Dept              T58
3            Dept              T59
Using the data above I want to set a filter condition on another table prior to printing named planrep. Therefore how can I set up a filter condition so it reads the table above and sets the filter on my planrep table? So for user number 3 it will set the filter so that the country=Morocco and Country=Ukraine.

Is there any eay way to do this?
Neil Lewis
IT R&D Manager
Velmore Ltd
Next
Reply
Map
View

Click here to load this message in the networking platform