I have 2 files company table and child contact table.
ncompany_id is interger and child contact table contains ncompany_id as a foreign key.
My problem is I could easiy set the relation to the child table. But i would like to display the child tables related records on order of the Surname.
I'm displaying parent and child details in a grid so when i move the parent record, i can easily display the corrosponding child records. But i do like the display order to be Contact.Surname. How can i do this?
Thanks in advance
I'd not recommend accessing the tables directly like that. I'd use SQL and create a cursor for the child grid. Make the cursor updatable and it becomes like a view. However, if you want to do it directly...
index the child table
INDEX ON PADL(STR(ncompany_id),10)+Surname TAG newtag
then from the parent table
SET RELATION TO PADL(STR(nCompany_ID,10)) INTO Contacts -- Mike Yearwood
( Topic last updated: 2005.10.26 10:58:49 AM )