Relationship setup with code?

[TheNoocH]

I have a table (table 1) that is created via import text specs...this has 2 key fields which is set up via relationships to another table (table2)...what i want to do is replace table 1 each time i run the import and retain the relationship to table 2...but since i have relationships b/t the tables it won't do it properly...any ideas? how bout is there a way to code the relationship setup...what i'm thinking is i could create code to do the following things:
1) delete the relationship b/t the 2 files
2) delete table 1
3) import via text specs to table 1
4) reestablish the relationships

any ideas how to do this or do it another better way?

 

[Norie]

Why not import into an existing table which already has the relationship set up?

 

[TheNoocH]

that's what i was trying to do initially but it kept giving me 0 records updated...what i tried and seems to be working is i put a sql in the macro b/f the import that does the following.....delete * from extract....so essentially i'm deleting all the records from the table...then importing the new data into the existing structure of the table (with the relationships and everything set up)...sound like the right thing???

 

[Norie]

Sounds right, does it actually work?

 

[TheNoocH]

it appears to in my initial tests...i'll have to keep hammering on it to make sure it won't break...thanks for your ideas...i appreciate it...