I use FM pro 11. I normally create multiple table occurrences to create relationships. As a general question, is it a good practice to create multiple relationships with the same fields relating two tables, but that are to be used for different purposes?
Table A and Table B are related by customerId. I created two relationships using customerId on both tables. I use one relationship to go from one menu (Table A) to another menu (Table B) to view related records. I use the other relationship in a script to perform calculations.
I guess my main question is if having many relationships in a database causes performances issues in the database?