Creating relationships in code

[Jozef]

Hello,

Is there a way to create a relationship in Access the same way you create a
table, field and indexes? When I do a search I get all sorts of manual
instructions (click the relationship button, click and drag on one field to
the related field yada yada) but nothing on how to manipulate (add or
delete) relationships using code.

Any help would be great!
Thanks!

[pietlinden]

HINT: Open the CODE window... create a module. Then go into help and
search for DAO, CreateRelation

[Jozef]

Damn I hate Access help! How come CreateRelationship doesn't show up in my
help search, yet if I navigate through a whack of other pages I find a "see
also" that says "CreateRelationship"

Thanks for the hint.

<pi********@hotmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

HINT: Open the CODE window... create a module. Then go into help and
search for DAO, CreateRelation

[Mike MacSween]

"Jozef" <SP**********@telus.net> wrote in message
news:0%nze.1897758$6l.284624@pd7tw2no...

Damn I hate Access help! How come CreateRelationship doesn't show up in
my help search, yet if I navigate through a whack of other pages I find a
"see also" that says "CreateRelationship"

Thanks for the hint.

Anything to do with code you need a code window open. VBA help is seperate
from Access help, I think.

But you're right. Access 2000 help is awful.

[pietlinden]

Yep, Access "help" is a bit of an oxymoron. and if you're looking for
help on something you don't know the exact name for, well, forget it.
And DAO is not the default library after A97, so it's only lazily
documented. Makes me miss the days when companies used to print big
fat manuals. At least you could find answers there.

[BillCo]

As the versions of access roll on the info supplied in the help files
diminishes. from A97 help using northwind.mdb you could pretty much
learn everything - I think it's a ploy to get us all to go on MS
certified courses. God I HATE that dancing paperclip...

[Jozef]

Hahaha! I hear you! and that damned SEARCH DOG!
"BillCo" <co**********@gmail.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

As the versions of access roll on the info supplied in the help files
diminishes. from A97 help using northwind.mdb you could pretty much
learn everything - I think it's a ploy to get us all to go on MS
certified courses. God I HATE that dancing paperclip...