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


>
> 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