>Can anyone please tellme how to do the following.
>
>I have table called Person.dbf which has two fields, code and name.
>The second table called Book.dbf which has many fileds but one
>field is called code which is the code from Person.dbf.
>
>I have set a relation between the two, but when I display the
>records in a grid, all the fields from book.dbf show in the grid,
>but the person.name does not show in the grid. It defaults to the
>first field in the book.dbf.
>
>Any suggestions
>Fida Shamsoodeen
Fida,
Think of using views also. Till then to do it old (for me still current) way I would rather suggest two grids, one for person and the other for books.
-Put both tables in dataenvironment and do not set any relation.
-Set order of books to code (I think it's the link field).
-You can set order of first to anything you like.
-Never change order of books or be sure the new order starts with code field. ie: index on code + dtos(borrowed) tag byBurrow
-In first grid just put person fields.
-In second books and set second grid properties as follows :
Linkmaster = "person"
Childorder = "code"
RelationalExpression = "code"
That's all.
Cetin