Child to Parent Multi Select Lookup Field
Currently, I have a relationship that looks like this:
Recently, we've come to the conclusion that protocols are going to be attributed to multiple alliances. but the way the current relationship works there can only be 1 related alliance to a protocol. If I was to make this a Many to Many I would lose the value of the alliance field, (id have to create a new alliance for every protocol.
Is there a simple way I can get this done. Basically, all I am trying to achieve is to be able to multi-select 1 of 20 alliances from the alliance table and have the protocols linked to whatever I've chosen. That way when i look at the alliance table I can see a report link of the related protocols.
I know I can make duplicate relationships but this number could grow to over 5 related alliances per protocol.
Recently, we've come to the conclusion that protocols are going to be attributed to multiple alliances. but the way the current relationship works there can only be 1 related alliance to a protocol. If I was to make this a Many to Many I would lose the value of the alliance field, (id have to create a new alliance for every protocol.
Is there a simple way I can get this done. Basically, all I am trying to achieve is to be able to multi-select 1 of 20 alliances from the alliance table and have the protocols linked to whatever I've chosen. That way when i look at the alliance table I can see a report link of the related protocols.
I know I can make duplicate relationships but this number could grow to over 5 related alliances per protocol.
