I am looking for an unambiguous definition of a subtable (if one exists). Is it:

- 2 tables with the same primary key

- Any one-one relationship. Simply select one to be the subtable.

- The subtable must contain particular info which is related to the info in the main data table (eg EMPLOYEE main table and MANAGER subtable).

Thanks!

Hey Patrice and welcome to the city that believes there is no greater impediment to the advancement of knowledge than the ambiguity of words. :rolleyes:

I looked around and found these docs. If yer a better carpenter than mme (easily accomplished), they may help you.

http://www-306.ibm.com/software/data/informix/pubs/library/datablade/dbdk/overview/glossary.fm.html#1360422

http://www.objs.com/x3h7/sec8.htm (FIND on subtable)

It's starting to make more sense now. Thanks!