Identifying/Mapping relations w/in tables?

Hello,

I have a Database with around 25 to 30 tables, my problem is that the relationships aren't very apparent. Example, I have a table called "PhoneOwner" that contains as a PK, "acct_num" also a non-pk field called "charge_id". I have a second table called "IDNames" which contains 2 fields: "ID" (<-- PK) and "Names" (non-PK). Between the two no obvious relation exists (no FKs).

However, after massive dabbling (back-and-fourth from application to tables) I've discovered the connection between
"PhoneOwner" and "IDNames". Basically, from an input box a user types a name which sets IDNames.Names which automatically increments IDNames.ID then PhoneOwner.charge_id is then set to IDNames.ID.

My question, is there any way to make tracking these relationships less mind boggling? If I set up a trace in SQL Profiler will this show me exactly which values are being set to what when dabbling w. the application?

Thanks a bunch!

I'll put in a good word to Santa for those who can help me...eh..eh