agentj
Technical User
- Dec 31, 2003
- 10
is it possible to delete relationships once they are made?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
deleting relationships
- Thread starter agentj
- Start date
- Status
vbainchicago
Technical User
Yes. You can just right click on the relationsip "line" in the relationships view and select "delete".
Keep in mind, depending on the structure of your database this could potentially cause problems.
VBAinChicago
Keep in mind, depending on the structure of your database this could potentially cause problems.
VBAinChicago
Keep separate two ideas.
Relationships are key/foreign key relationships that Access uses to make default joins for you in certain contexts eg Query-by-Example Screen. These have no other substance until you create a query with a join. Access will use relationships to fill in certain field properties if you use wizards. You create joins at run-time and in doing so override anything in the relationships screen/diagram.
Referential Integrity Constraints are constraints that will be imposed by the database without you issuing any further coding. If you change the rules of your database you can't easily override these at run-time. Referential Constraints do not join tables. They simply ensure that information in related tables is consistent so they watch two or more tables but won't eg display information from a table just because you mention a table that shares a constraint .
Relationships are key/foreign key relationships that Access uses to make default joins for you in certain contexts eg Query-by-Example Screen. These have no other substance until you create a query with a join. Access will use relationships to fill in certain field properties if you use wizards. You create joins at run-time and in doing so override anything in the relationships screen/diagram.
Referential Integrity Constraints are constraints that will be imposed by the database without you issuing any further coding. If you change the rules of your database you can't easily override these at run-time. Referential Constraints do not join tables. They simply ensure that information in related tables is consistent so they watch two or more tables but won't eg display information from a table just because you mention a table that shares a constraint .
- Status
Similar threads
- Locked
- Question
- Locked
- Question