THANKS! this is the one i've been looking for.

> > hi to all:
> >
> > is it possible to create a relationship between tables on the database programmatically. if it is, can you please give me some sample codes.
> >
> > thanks a lot guys!
> >
> > ( ", )
>
> Hi Mischelle.
>
> Are you referring to referential integrity?
> If so, do mean that after you run a program to create the ref integ, you will be able to see the graphical lines showing the relationship when you modi database?
>
> Or, (this one I know)
>
> Use EmpFile
> Use OrgnTable in 0 order OrgnCode
> Use PositionTable in 0 order PosCode
> set relation to EmpFile.OrgnCode into OrgnTable
> set relation to EmpFile.PosCode into PositionTable additive
> Use SalaryTable in 0 order SalLevel
> sele PositionTable
> set relation to PositionTable.SalLevel into SalaryTable
> sele EmpFile
>
>
> EMPFILE
> Name
> OrgnCode Index Key
> PosCode
>
> ORGNTABLE
> OrgnCode Index Key
> DepartmentName
>
> POSITIONTABLE
> PosCode Index Key
> NameOfPosition
> SalaryLevel
>
> SALARYTABLE
> SalaryLevel Index Key
> BasicPay
>
> Rene-PCSO


( ", )