Im going to use some federated tables that I need but I know that the engine does not support foreign keys.
Im thinking of alternatives and this is the one so far:
Tables from the remote side and related related with a foreign key on the local side.
Its the only way I can think of to keep the relations I need. The other one would be not to relate any table at all but obviously this cant be done.
Suggestions? Thank you