Dts- To 2 tables

[Guest_imported]

Hi,

Here is my destinations tables:

People Table (Id,Name,City) //Id is auto-generated
Car Table(Idpeople,Model)

One person could have several cars which are linked by the IdNumber.

How can I use Dts from my source view to these 2 tables ? In fact how to retrieve the Id generated in 'People' table to put the right number when writting in 'Car's field Idpeople using Dts ?

Someone has an idea ?

Thanks

Vincent

 

[DLanouette]

Try first adding the poeple records
then use a lookup when adding the Cars (see the help).

Or, alternately, copy all the data into a temp table and add a field for the Poeple ID. Then add all the data to People from this temp table. Go back and update the People ID in the temp table. The just add the info to Cars from the temp table.

 

[DLanouette]

Try first adding the poeple records
then use a lookup when adding the Cars (see the help).

Or, alternately, copy all the data into a temp table and add a field for the Poeple ID. Then add all the data to People from this temp table. Go back and update the People ID in the temp table. The just add the info to Cars from the temp table.


______________________________
- David Lanouette
- Lanouette Consulting, LLC
- DLanouette@Computer.org