AnsweredAssumed Answered

Assign multiple values to foreign key?

Question asked by scheeja on Nov 30, 2018
Latest reply on Dec 3, 2018 by ibrahim_bittar


Hey all!

 

I have a solution that tracks sales leads. I'm trying to make it so that you can assign more than one Sales Rep to a single Lead, and of course a Sales Rep can be assigned to many Leads. Any ideas on how this could be done?

 

I was thinking of using a repeating field as the Sales Rep's foreign key on the Lead table, but haven't used repeating fields much and have heard to stay away from them.

 

Thanks!!

Outcomes