Hi Sam, I think I would use Before-Insert-Triggers within oracle to solve foreign-key-Problems. Christine
----- Original Message ----- From: sun761980 To: [email protected] Sent: Sunday, July 22, 2007 4:06 PM Subject: [fme] upload in multiple relational tables in a single session Hello i have a feature object, utility which i have split into 4 relational tables in oracle spatial database, Utilityinformation, utilitypoint, utilitycurve and utilitysurface. Utilityinformation is a parent table to other three tables and they are all linked via foreign key utilityinformationID i am trying to upload bulk data into these tables using FME workbench. 1. Is it possible to upload bulk data in a single FME workbench session 2. how can i maintain utilityinformationid as first it will be created in parent table utilityinformation and then it will be related in other child tables utilitypoint, utilitycurve and utilitysurface regards sam
