Documentation of Relation Attributes

[JGPatrick]

Apologies for making so many posts, but if Microsoft had better online
documentation I wouldn't have to ask this next one. Is it just me or does
Microsoft seem to leave ALOT out of their online doc? Is there some monster
reference manual we can buy that will have all this stuff?

Where can I find documentation for DAO relation attributes? In other words,
a list of attributes, with a brief definition of what they mean? This is
necessary if you want to add relationships to your database schema in DAO.
For instance, if I wanted to create a left outer join between two tables and
cascade updates, I know that the way to do this is to assign a certain value
to the attributes property of a relation object, but what value to assign I
have no clue.

Many thanks.

PS: I'm not looking only to execute only that one example; I would like to
have the entire list.

 

[David C. Holley]

Establishing relationships between tables is most commonly done using the
GUI.

Access 2003 TOOLS>>>RELATIONSHIPS
Access 2007 DATABASE TOOLS >>>RELATIONSHIPS

Extensive documentation can be found here on the entire Access Object Model
and DAO.

http://msdn.microsoft.com/en-us/library/bb979619.aspx
http://msdn.microsoft.com/en-us/library/bb244865.aspx

I would *VERY HIGHLY RECOMMEND* that you block out some time and just browes
through the articles.

 

[Gina Whipp]

JGPatrick,


We have Crystal's video for that...
http://www.accessmvp.com/strive4peace/Index.htm About half way done you can
read all about Relationships! OR, you can go to the site where the online
documentation is from Microsoft
http://office.microsoft.com/en-us/training/cr101582831033.aspx

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Allen Browne]

You must be writing some kind of wizard-type app if you need to create
relationships in code.

Here's an example of creating a relation with DAO and setting the
attributes:
http://allenbrowne.com/func-DAO.html#CreateRelationDAO

Once you see how to set the attributes, the constants (members of
RelationAttributeEnum) are self-explanatory. To see the list, use the Object
Browser (press F2 in the code window.)

The only one I'm aware of in JET 4 that's not documented is cascade-to-null.
For a sample database that illustrates that one, see:
http://allenbrowne.com/ser-64.html