Relationship & sql

B

Braham B

Thanks in advance

We have access font end with sql 2000 server as backend.(API)

We have a foreign table link. (With three relationships)

What I want to do is change old table (Foreign Link) to New table (same
foreign Link) (Thus deleting the relationships and adding new ones)

Then I want to add three new relationships to that table with the new
Foreign Link. (Which I can do manually but need to do through code)

Using access 2000.
 
Top