Re: Entity-relationship between tables

As request by you to post the ouput of script, pl. have a look at below: ----------------------------------------------------- Example: $depend.sh authority aunrmast Searching for tables that (aunrmast) has an FK to: Searching for tables that refer to (aunrmast) with an FK: Searching for Parent tables for potential view (aunrmast): Searching for Child tables for table (aunrmast): - Child of View : auapview - Child of View : auarview - Child of View : avdmappl - Child of View : avinview - Child of View : avrpy055 - Child of View : aunrview - Child of View : avdminfo - Child of View : avdminfo - Child of View : avdminfo - Child of View : avesdocs - Child of View : avesname - Child of View : avnrmast - Child of View : ev_name_link_dd - Child of View : ev_action_officer - Child of View : ev_name - Child of View : ev_login - Child of View : ev_name_link - Child of View : ev_animal_owner - Child of View : ev_animal_owner - Child of View : ev_creditor_bal - Child of View : mb_view4 - Child of View : debtrecovery - Child of View : ev_debtor_detail - Child of View : ev_debtor_detail - Child of View : ev_debtor_detail - Child of View : ev_debtor_detail - Child of View : ev_debtor_detail - Child of View : ev_tender_current - Child of View : ev_tender_current - Child of View : ev_task - Child of View : xp_people - Child of View : xp_creditors - Child of View : xp_council - Child of View : ev_debtor_bal - Child of View : gispostal - Child of View : ev_property - Child of View : ev_name_doclink - Child of View : ev_resp_officer - Child of View : ev_app_appeal - Child of View : ev_action_bal --------------------------------------------- Cheers, Hari "Ma, Thanh(IndSys, GE Interlogix)" <Thanh.Ma@ge.com> wrote in message news:bbg5mt$461$1@terabinaries.xmission.com... > > Hi, > > When I delete a record I would like to delete all of its associated records. > Is there a handy tool somewhere that let me identity what the associated records are ? > > Thanks, > Thanh >