I have a situation that some of you may be of help. I will name the tables
specifically so you can understand what I am talking about.

I have a COS_species table....the information in it cannot be changed.

Everything in this database is pretty much centered around the speciesID. We
also want other species that are no included in the COS_Species table.
Specifically....we want to be able to handle multi species which would
contain many of the species from COS_Species.

So...I would create a new table called Multi_Species and then a linking
table MultiSpeciesLink to link the 2 tables together.

The problem is....since everything is supposed to be centered around the
SpeciesID, how do I manage that since a speciesID can come from 2 different
tables?

Thanks for any input.