parent child initial loading
Posted: Fri Aug 14, 2009 11:36 am
Dear All,
I have two empty master detail tables say journey (journeyid is PK) AND Trucks(Truckid is pk,journeyid if FK)
i have loaded master table records and i need to load second table Trucks where i need to populate journeyid values from Journey table.
as Trucks is an emptty table ,i dont have any matching keys bewteen Journeys and Trucks.then how can i load the trucks with journeyid column from master table journeyid values.
can any one suggest me on this about approach.
thanks
raj
I have two empty master detail tables say journey (journeyid is PK) AND Trucks(Truckid is pk,journeyid if FK)
i have loaded master table records and i need to load second table Trucks where i need to populate journeyid values from Journey table.
as Trucks is an emptty table ,i dont have any matching keys bewteen Journeys and Trucks.then how can i load the trucks with journeyid column from master table journeyid values.
can any one suggest me on this about approach.
thanks
raj