Request for idea

Discussion created by reeflifeapps on May 3, 2016
Latest reply on May 3, 2016 by coherentkris

Good day,

I am developing an fm14 database and am stuck on how to accomplish something.


I have many tables, but two of which are the issue.  I have a database (table) of several thousand marine species, called "species".  I have another table that contains the global oceans divided into 188 different sub regions, called "subRegions".  Naturally, each species can be found in multiple sub regions.  Not sure how to set up the relationship to accomplish this.  The subRegions table had "id", "name", and "coordinates" as it fields.


It is easy to set a foreign key to the subRegions id, from the species id, but how to set this so that multiple regions can be displayed, per species, at once?


Thank you, David