When you add an IDO, you must identify a primary base table. If there are columns in other tables that have a relationship with the primary base table and if you want to expose these columns as properties on the IDO, you must also add the related table to the IDO as either a base table or a secondary table.
What is the Process of Adding Base or Secondary Tables to IDOs?