>Hi all,
>
>
>
>I have three tables
>
>Table A contains the fields RefPeriod and total
>
>Table B contains the fields RefPeriod, refColor, Period and year
>
>Table C contains the fields RefColor and Color
>
>I would like to be able to put those informations in a grid with columns defined as
>
>Period Year Color Total
>
>
>I would like to have the information sorted by color.
>
>This grid will be on tha scond page of a PageFrame. The first page is the entry form. I want to bel able to select a column in the grid and return to the first page to edit that record.
>
>How can I do that?
>
>TIA

Create a view that combines the fields as you desire that will become the .RecordSource of the grid on page2. It is quite common to use a list on page two of a pageframe to let a user select a record in which to edit. I do this for small data maintenance forms which have small lists. I use the .DblClick event of the textbox in the grid to call a form level method which places the record the user just clicked on into the form controls on page 1.

Steve