Hi!

Take a look to CREATE SQL VIEW command in help. You can create it programmatically. Query for view created programmaticall can contain any SELECT statement you want, it just would be not editable by view designer visually.

HTH.

>Hi,
> I have 5 tables:
>

>Table : tblBacklog
>Fields :
>    CtrlCode     (Primary)
>    LogCode
>    RefDept      (Relation : tblDepartment.RefNo)
>    RefDelay     (Relation : tblDelay.RefNo)
>
>Table : tblEmpAssign
>    CtrlCode
>    LogCode
>    Emp_Code
>
>Table : tblEmployee
>    Emp_COde
>    Emp_Name
>
>Table : tblDepartment
>    RefNo
>    Dept
>
>Table : tblDelay
>   RefNo
>   Delay
>
>I would like to combine all of these to be a cursor as the following
>tblBacklog.CtrlCode
>tblBacklog.LogCode
>tblDepartment.Dept
>tblDelay.Delay
>tblEmployee.Emp_Name
>
>I would like to allow use to update the fields of the above, tblBackLog.RefDelay, tblBackLog.RefDepart, tblEmpAssign.Emp_COde
>
>

>
>How should I design it?
>
>Thankl you