Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relation
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00806659
Message ID:
00806808
Views:
16
Try
select products
SCAN WHILE products.id = client.id
  * DO whatever 
ENDSCAN
>The parent table is client (fields id and name)
>
> The child table is products (fields product and id)
>
> I've created a relation and a form with 2 pages
> The first page has the client data and the second page has a grid
> with the products of the client
>
> It works nice
>
> I created a button to pass the products of a client to a txt
>
>    select products
>      skip + 1
>        store product to line
>          ** do record_txt.prg
>           skip + 1
>          store product to line
>            ** do record_txt.prg
>
> The problem is that the child table is not limited to the
> relation with the parent table as the grid is
> All records go to the txt.
> I need only the records related to the client that the
> I am now in the child go to txt
> How can I do ?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform