linking tables with code

[HanneSThEGreaT]

Hello, I'm relatively new to database programming. I've created this database with about 15 tables, I want to link one table with the rest with visual basic code OR with MS Access, but the problem with MS Access is that whatever I try doesn't seem to work...

Please Help

F. T. W.

[Cimperiali]

Is it an Access db?

Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater

[HanneSThEGreaT]

Yes an Access 97 db. Can you help¿

F. T. W.

[Cimperiali]

>>OR with MS Access
if you want to do it statically, go to menu Tools and select Relations. To do it dinamically, create a module and have a look at sintax of:

Dim db As Database
Set db = CurrentDb
db.CreateRelation
Hope this may help
Cesare


Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater