Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Navigate to the particular record in the child table
Message
From
25/06/2001 08:03:34
 
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00522661
Message ID:
00522985
Views:
7
This message has been marked as the solution to the initial question of the thread.
>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.

PMFJI, Nadya,

I think you've already got the answer yourself...

Have the relation set up on town, but the index on the child as town+Street
The relation will find all the records in the child table with the same town..

Then in the Parent browse valid you can Seek(Town+Left(Street,1)) in the child

This should put the child record pointer in the correct location but you can still navigate to any other streets.

The only problem with this methodolodgy is if you have a town called "New" & a street called "Castle Street".. then another town called Newcastle they will all be retrieved..
You can get round this by putting a seperator in the index and the Seek command.

HTH
Will Jones
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform