In Base's New Relationship pane (Tools -> Relationships), how is the cascade
direction determined? Take the classic 3-table example of [Department -
Employee - EmployeePix] with these relationships:
Department (1) - (n) Employee (each Department record links to
multiple Employee records)
Employee (1) - (1) EmployeePhoto (each Employee records links to one
EmployeePhoto record)
Between a Department and its Employees, there /might/ be a cascade
relationship - that is, if a Department is deleted, all of its Employees are
deleted - but that's typically not a concern. What /is/ a typical concern
is that if an Employee is deleted, the linked EmployeePhoto record is
deleted - but not the other way around: One might need to delete or change
an EmployeePhoto without deleting or changing the Employee. So there is a
clear unidirectional cascade. How does Base determine that direction?
John
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
