[?] Print table columns with relation to other tables?

I need to teach some people how to use SQL and Ace in their application. Before doing this I need to become familiar with their application tables, especially those fields (columns) that have a referential relationship to fields in other tables. I will be needing to do join queries and would like to have these field relationships readily apparent. Is there a way, in Informix SQL 4.00 or 4GL, to produce a report of all the tables in a database which also shows the links between the referential fields? I am hoping I don't have to print out each tabl individually and manually inspect them for relationships to each other. Thanks. -- Bill Irwin - The Westrheim Group - Vancouver, BC, Canada ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ bill@twg.bc.ca 604-431-9600 (voice) | UNIX & Network 604-430-4329 (fax) | Systems Integration