I've come into the middle of a "complicated" project. Wondering if there are any ways or products to test a FM solution. Like to make sure all the databases are linked right and all the fields are correct, etc.
This won't do all that you're asking for and it has its flaws, but if you have FMP advanced, you can generate a Database Design Report in HTML format. You can then use "Find" to search for the key words "Missing" and "Unknown" to spot many errors due to broken or missing links.