I have 3 FMP databases. The information fields in each are different, though some, such as name, are the same. To my understanding they are separate databases. These are research dbs with information gathered from different sources so combing them all in one db would be difficult, large and might not be the best use.
Can I insert a field in one that would reference the other 2?
If not, can I create a db that references all 3?
I have been using FMP for a long time but am trying to get more use out of the thousands of records that I have.
Any help or suggestions appreciated.