PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WEBDEV 2024 → Filter for a Table
Filter for a Table
Débuté par Dan Matis, 08 déc. 2008 08:07 - 1 réponse
#1
Posté le 08 décembre 2008 - 08:07
WebDev12

Newbie here, I have a program where I am showing 1 company (on top) then I have a tab below which on one of the tabs I am trying to show only the related contacts for that company in a table ...

How do I filter? to only show the related contacts?

Thanks in advance ... Dan
#2
Posté le 08 décembre 2008 - 13:34
Hi Dan and welcome...

There are several different ways of doing that...

You can use a query or a hfilter...

with a hFilter, you would have to do, each time you change company,
something like (I do not know your files, so it's of course just an
example):
hFilter(Contact, KeyByCompanyIDAndContactName,
[Company.CompanyID,hMinValue],[Company.CompanyID,hMaxValue])
then loop on your contact file to fill the contact table (if memory
table) or redisplay your contact table (tabledisplay) if it's a file
linked table

One more thing: this kind of operation is described in quite details in
the auto-formation guide coming with the product, so I strongly advise
you to follow it in details... The few days you'll spent on it will be
extrimely profitable

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on http://www.fabriceharari.com


Dan Matis wrote:
WebDev12

Newbie here, I have a program where I am showing 1 company (on top) then I have a tab below which on one of the tabs I am trying to show only the related contacts for that company in a table ...

How do I filter? to only show the related contacts?

Thanks in advance ... Dan
→ Revenir à WEBDEV 2024