Many-to-Many Perform Screen
Posted in 1994
How would you establish ISQL Perform Screens for the following M-to-M relationship. One-to-many relationships fit the master-detail relationship, but how does one set up a Many-to-Many relationship. The many-to-many relationship is needed because some employees (secretaries) are members of several departments. Other table columns (attributes) are not shown to simplify the problem. ER Diagram ---------- ------------ /\\ ------------ | | M / \\ M | |----( SS_# ) (Dept_# )--|Department|____ / \\ ____ | Employee | | | \\DEPT_EMP/ | | ------------ \\ / \\ ------------ \\/ \\ \\ \\ (Dept_#) \\ (SS_#) TABLES PRIMARY KEY ------ ----------- Department Dept_# Employee SS_# DEPT_EMP SS_#, Dept_# Mike Petersen mgp@nwedim.att.com (708) 224-4838 AT&T Lisle, IL /**********************************************************************/