Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ordering child table
Message
 
To
13/04/1998 11:46:40
Criss Jensen
Injury Prevention Research Center
Iowa City, Iowa, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00091550
Message ID:
00091552
Views:
18
>I have a parent table (Person) and a child table (Address). Is a grid the best way to display the addresses for a person? How do I get the most recent address to be at the top of the list/grid? After reading the help on the ChildOrder, LinkMaster, and RelationalExpr properties, I'm totally confused. Do I need to use all three of these to set
>up my one-to-many relationship? Isn't that overkill? HELP!!!
>
>Thanks,
>Criss

I personally prefer to use parameterized view as a grid.RecordSource in one-to-many form. If you have several address records in child table, you may have timestamp field in it, and ORDER your view on that field DESCENDING.

HTH,

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform