Re:how to check the relationship in tables

From: Vishal Parkar (vgparkar_at_hotmail.com)
Date: 04/28/03 

Date: Mon, 28 Apr 2003 05:00:26 -0700

You can create sql server diagrams which will give you a
good visibility about the master-detail relationship
between the tables for a particular database.

--Vishal

>-----Original Message-----
>Dear Friends
>
>My company have purchase the software of accounts and now
>my management want that i should give the Data access
page
>access to the other users who are not working in accounts
>for there suppliers.
>
>There are 429 tables in the application and i want to
>search for the transaction table and master table for
>particular supplier.
>
>Please suggest how i can check for the relationship
>between the tables.
>
>your guidence will help me to solve the problem.
>
>thanks and best regards
>niitmalad
>.
>