>>Hi everyone,
>>
>>This is Foxpro 2.x question, which my colleague just asked me.
>>
>>There is a parent and a child table, which are related by town. The user wants to navigate on the parent table and see record displayed at the child table, which has the same first letter of the street, as the parent table. I have an idea about using temp index with two tables, but it's not a good solution.
>>
>>The problem here, how can we know, that user navigates, since its Fox2.x question and we don't have all events...
>>
>>Can you help me, please?
>>
>>Thanks in advance.
>
>Hi Nadya,
>
>First, create an index in the child table based on the town and 1st letter of street and set the relationship between the two tables
>
>

SELECT Child
>INDEX ON town + left(street,1) TAG LookTown
>SELECT Parent
>SET RELATION TO town + left(street,1) INTO Child
>

>
>Now, as you navigate Parent, the desire records in Child will be ready to view. If the field length of Town is not the same in the Parent and Child tables, you'll need to add PADR to the index and relation to make them work properly.

David,

This is not that we need. User should be able to navigate to any street in child table. But she wants to start from the street with the same first letter as in the parent table. I was thinking about using Browse valid() or when(), but my colleague has to investigate this possibility, because she never used them before. I also could not recall details, because I stay away from Fox2x for couple of years. Currently she said, that the user wants too much from this application, which is already overloaded with functionality.