When adding child tables, it is required to designate a foreign key column to each child table so that a relationship to the parent table can be defined: 
1) Select the User Key check box for the foreign key column in the child table. A key icon is displayed next to the column name. 
2) Then specify the relationship between the primary column in the parent table and the foreign key column in the child table by clicking the "Join To" field of the child table column, and select the name of the parent table primary key column from the drop-down list. Then click "Apply" button. 

When a column in parent table having adbDateTime datatype is defined as 'primary key' and is also having Join-To relationship to the child table, then TIBCO ActiveMatrix Adapter for Database throws below exception:
=========
"com.tibco.adapter.adb.database.DBSQLException: java.sql.SQLException: [tibcosoftwareinc][Oracle JDBC Driver]Unable to determine the type of the specified object. when bind child selector".
=========
This exception is caused by passing 'java.util.Date' into a prepared statement rather than a 'java.sql.Date'.TIBCO ActiveMatrix Adapter for Database is based on Java-based SDK and is using JDBC driver to connect to the database. It handles JDBC date/time/adbDateTime datatype by using AEType as "adbDateTime". As such, if a table has a column with adbDateTime datatype as key field then it can not be used to specify Join-To relationship between parent and child table. However, "adbDateTime" type is not a valid JDBC type.