Anybody have any Idea About this - Realtionships

  • Thread starter Thread starter Sage Morales
  • Start date Start date
S

Sage Morales

I created a database called "folder"
I have many tables all related to each other:

tblseller (main)
tblbuyer
tblclosing
tbllistinglog
tblmortgage
tblseller
tblremarks
tblchecklist
tblmonetarytrans

I put a record in all tables as primary called "folde_id"
how do I link so that when I create data access pages for the web they can
all be linked to one another
 
If I understand you correctly, you should have setup/normalized the tables
so that each related table has a foreign key and is related 1-many with the
main table. Such as:

tblSeller
sellerID = primary key
sellerName
etc.
tblBuyer
buyerID -primary key
buyerName
etc.

tblClosing
closeID -primary key
sellerID -indexed + set related to tblSeller
buyerID -indexed + set related to tblBuyer
closeDate
etc.

If you setup yout database like the above, and turn on the "relational
integrety", the links will be inherited by all queries and ASP's.
-Ed
 
Back
Top