I have a grid connected to a table, TIMESHEET. TIMESHEET is related into 2 tables.

select Timesheet
set relation to project into project, project+task into tasks

GRID
column 1 is Timesheet.project
column 2 is Project.descrip
column 3 is Timesheet.task
column 4 is Tasks.descrip

What I want is when I type in a project in column1, project descrip appears, and column4 is blank until I type in a task into column3.

The project.descrip (column 3) is working great, but as soon as I type in a project into column1, the task descrip comes up with a descrip that is not related to the project.

Any ideas?