I have a many-to-many relationship between an Employee and a Plan. The cross table is called EmployeePlan.
This was all well and fine until we added Dependents into the mix. Each Employee has many Dependents. The tricky part is that each Dependent can be associated with any or all of the Plans that the employee has. So basically, there is a many to many between Employee and Plan, and there is a many to many between Dependents and the *cross table* EmployeePlan. How do i map this? is there a better way than a many-to-many to a many-to-many? thanks! Ralph
