>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
If you want to use a grid to show fields from multiple tables, you'll need to set the ControlSource property of each column individually, so that the Grid control loads data from the proper table and field in the correct order. If you're just setting the RecordSource to Book.DBF, there's no way for the grid to know that some data comes from Person and other data from Book. Setting the ControlSource for the fields explicitly lets you control which fields, from which tables, are shown in the grid.
An alternative would be to do a SQL Select or view that joined the tables and provided a single cursor containing fields from both tables - you could then use the cursor as the RecordSource for the Grid, and then the columns wouid inherit the fields from the cursor.