> ---------------------- > molecule_info > ---------------------- > mol_id > mol_name > ----------------------- > > ----------------------- > plant_info > ----------------------- > plant_id > plant_name > ------------------------ > > here, i one mol_name is found in more than one plant_name. > the same way, one plant_name has more than one mol_name. > how do i make them one-to-many.
You're most of the way there. You need a third table with the two IDs: join_table -------------- mol_id plant_id So if molecule 1 is found in plants A, B, C, and D, and molecule 2 is found in plants B, D, and E, you'd have seven rows: mol_id plant_id 1 A 1 B 1 C 1 D 2 B 2 D 2 E -- Whil Moving to Linux: Freedom, Choice, Security, Opportunity http://www.hentzenwerke.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
