Find or show MySQL table relationships in FM
We purchased a MySQL data base for managing our photography business. It does some of what we need but it is not very user friendly and the vendor isn't inclined to make chages or be very helpful. I've been able to bring tables into FM and and view the fields but haven't been able to figure out how to find or show the existing relationships between the fields in the tables.There are 72 tables with a few to many fields in each table and the field names don't seem to match from one table to the next. Is there a way or a program that will display the linkages without having to hunt through every field by hand?
No you will have to get it from the MySQL side.