Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting filter conditions based on records in a table
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Setting filter conditions based on records in a table
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01074912
Message ID:
01074912
Vues:
43
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform