Relationships and Importing

[Don]

I'm trying to get information from a database that has
relationships.

I can import the data, and maintain the relationships, by
pressing Right Click in the database window, selecting
Import, chosing my database and checking "Relationships"
under Import.

Is there anyway to do this programmatically?

Thanks.

 

[John Mishefske]

I'm trying to get information from a database that has
relationships.

I can import the data, and maintain the relationships, by
pressing Right Click in the database window, selecting
Import, chosing my database and checking "Relationships"
under Import.

Is there anyway to do this programmatically?

Sure. Check out DAO's CreateRelation() method.

Loop through the Relations collection saving the information
needed to re-create them with CreateRelation().