I have made two tables:
Id - int
Name - varchar
ClientId - int
PayFirmId - int
I lay the following relations:
Firm.Id => PaymentFirm.ClientId - rolename: client
Firm.Id => PaymentFirm.PayFirmId - rolename: payfirm
I get two the same errors: the role names for the two incoming relations for the associative table must match
I have changed the role name, I have made them the same, I put no names. Both the roles are defined on the Firm table.
The idea is that one firm can be a production plant, while the other firm (pay firm) is the financial institution that pays most of the bills. (Don't ask me, it's how the industry does it.) Can I put these two firms in a single table and set a reference
from this table to the PaymentFirm associative table and back? Or do I need to put one relation in the firm table and one in the payment firm table? Or do both relationships need to be in the associative table?
Any help is appreciated.