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
parent child initial loading
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 45
- Joined: Fri Nov 07, 2008 12:22 pm
Re: parent child initial loading
DSRajesh wrote: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
You need to find out the relationship between your Journey table and your Trucks table. Something like
One truck can make Many Journeys.
Then you can select JourneyId where truck = 'MyTruck'
Does that make sense?
-Hiral
Thanks,
Hiral Chauhan
Hiral Chauhan