Can a Business Object link back to more than one database table?
Yes. ObjectSight Business Objects are typically generated to access a single database table, but in more complex circumstances such as Business Objects descending from other Business Objects more than one database table may be referenced during a save operation. For example, a TdmoContact is based on the contacts table and is derived from TdmoPerson which links to the persons table. Thus, fetching a contact requires a join between the persons and the contacts table. This join can be defined as either INNER or OUTER JOIN. Save operations will then take into consideration that multiple INSERT, UPDATE or DELETE operations must be performed.
