Purpose
Creates a new Relation object
Parameters
cName | (Optional) A string that uniquely names the new Relation object. |
cTable | (Optional) A string that names the primary table in the relation. If the table doesn't exist before you append the Relation object, a run-time error occurs. |
cForeign | (Optional) A string that names the foreign table in the relation. If the table doesn't exist before you append the Relation object, a run-time error occurs |
liAtttributes | (Optional)A constant or combination of constants that contains information about the relationship type. |
Returns
Object of type DaoQueryDef or NULL_OBJECT when an error is encountered
Remarks
The liAttributes value can be a combination of these constants
Constant | Description |
dbRelationUnique | The relationship is one-to-one. |
dbRelationDontEnforce | The relationship isn't enforced (no referential integrity). |
dbRelationInherited | The relationship exists in a non-current database that contains the two linked tables. |
dbRelationUpdateCascade | Updates will cascade. |
dbRelationDeleteCascade | Deletions will cascade |
Class
Example