Child to Parent Multi Select Lookup Field

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
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.
Photo of Stephen

Stephen

  • 226 Points 100 badge 2x thumb

Posted 1 month ago

  • 0
  • 1
Are yout field, but the results should be

Are you essentially saying that you would like the data entry method to be a multi select field, but the result should be the creation and maintenance correct child records.

If that is your question I previously answered it on this forum and I can call back and see if I can locate my previous answer.
Photo of Stephen

Stephen

  • 226 Points 100 badge 2x thumb
Actually, I just got it, it was more simple than I thought of.  Basically, it was just adding an intermediate table between the alliance and protocols table. I don't know why i didn't think of that.