PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → Table on from called from another table. . .
Table on from called from another table. . .
Started by Ken Knight, Jun., 23 2005 6:52 AM - 2 replies
Posted on June, 23 2005 - 6:52 AM
Hi All,

I'm not quite understanding something here. Here is my setup.

Form with Table on it which is the Parent file. On this form I double click to "edit" the record. The form that comes up from the double click has edit fields and also a child table. These to databases are linked via a common field named ID which has been described in the Analysis.

How do I show ONLY the child records that have a matching ID in it?

This has got to be the most basic thing I can think of but I'm not getting Windev's use of relationships.

Thanks,
Ken
Posted on June, 23 2005 - 10:19 AM
Hello Ken,

Dans un message Ken Knight disait :

Hi All,

I'm not quite understanding something here. Here is my setup.

Form with Table on it which is the Parent file. On this form I
double click to "edit" the record. The form that comes up from the
double click has edit fields and also a child table. These to
databases are linked via a common field named ID which has been
described in the Analysis.

How do I show ONLY the child records that have a matching ID in it?


1) use a file filter on the child table ( condition : Childfile.ID =
numeriqueverschaine(ID) )

2) use a request based on the second table file with a parameter you supply
( ID) . If necessary use tableaffiche(childtable,tareexecuterequete)


[some orders are in french, but Windev understansd both FR and EN]

HTH
--
Michel HERRSCHER CONSULTANT
Président WINDASSO - Association des utilisateurs WxxDEV(c)
Tel : +33450870912 Fax:+33450871741
http://www.windasso.org
Posted on June, 23 2005 - 10:10 PM
Thanks so much for your reply. I got it working about an hour after I made the post, however, as we all know it can take many hours if not a day or so for a post to show up in this forum.

Are there any "active" forums that are immediant posting??? If not, I'll create one.

As for Windev, my first impressions are that I'm truly impressed with the scope of what it can do and how it does it, but IMHO there needs to be a community that is "realtime".

Cheers!
Ken