Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mischelle Quilala
  Where is Mischelle Quilala?
 Caloocan City
 Philippines
 Mischelle Quilala
 To: Rene Relucio
  Where is Rene Relucio?
 Quezon City
 Philippines
 Rene Relucio
 Tags
Subject: RE: hard coded table relationship
Thread ID: 22228 Message ID: 22242 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Saturday, April 12, 2003 2:53:32 PM         
   


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


( ", )

COMPLETE THREAD

hard coded table relationship Posted by Mischelle Quilala @ 4/12/2003 8:10:22 AM
RE: hard coded table relationship Posted by Rene Relucio @ 4/12/2003 9:21:22 AM
Interested in a GetTogether of Foxiters from MMla? Posted by Rene Relucio @ 4/12/2003 9:50:34 AM
RE: Interested in a GetTogether of Foxiters fro... Posted by Argie Badua @ 4/12/2003 3:28:39 PM
RE: hard coded table relationship Posted by Mischelle Quilala @ 4/12/2003 2:53:32 PM