Difficulties with making more than one association between tables
I am having some difficulties, please can someone give me some advice.
I have 4 tables which, when on data manager, are each connected by the field names year and organisation.
However, when I load the data, I find that an association is made between one field name but not the other. That is, a connection might be made between year and not organisation and visa versa. Please can you tell me why this is happening and how I can avoid it?