Resolution:
Assume you wish to subscribe into a table SF_PO_HEADERS_INTERFACE which has a child table SF_PO_LINES_INTERFACE joined by a foreign key on the column MESSAGE_ID:
1. configure a publication from the parent table, this generates a publication table (say SF_PO_HEADERS_IFACE_P) and repository classes for both tables.
2. configure a child relationship with table SF_PO_LINES_INTERFACE, this adds a sequence of child items to the publication class (SF_PO_HEADERS_IFACE_P).
3. configure a subscription into SF_PO_LINES_INTERFACE
4. configure a subscribing table relationship between SF_PO_HEADERS_INTERFACE and SF_PO_LINES_INTERFACE
5. publish a message contain the publishing class (SF_PO_HEADERS_IFACE_P) on the subject for subscription into SF_PO_LINES_INTERFACE
6. the data is inserted into the parent and child tables...

How do I subscribe into a parent/child table schema with ADB?

Product: TIBCO Adapter for ActiveDatabase Version: 3.3.1 OS: All --------------------