PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV Mobile 2024 → Filter comboboxes
Filter comboboxes
Débuté par Marco Voorwinden, 06 juil. 2009 19:20 - Aucune réponse
Posté le 06 juillet 2009 - 19:20
Hi,

I have a set of tables (e.g. table1 to table5) with data in it (all have 2 columns: Number, Description). Next to this I have other tables with relationships in it, so e.g. Table1_2 limits the records of table2 when you select an item in table1.
I now want to have a form with a dropdown for each table (drop1 to drop5), and when I select an item in drop1, I want drop2 to be filtered, based upon Table1_2.
Is there an automatic way of doing this? Should I use HFilter for this, or maybe FileToMemoryList? Because the amount of records can become quite large I do not want to go through the table record by record, using HReadSeekFirst, HReadNext...

I am using HyperFile tables.

Any suggestion would be really appreciated!!