Lookup fields in subform demanding unique values?

Lookup fields in subform demanding unique values?

I have a form for our program sessions that includes a subform for the purpose of listing participants.
The subform is a separate form, and includes three lookup fields:
  1. Name of the participant
  2. Sponsoring organization
  3. Occupational institution
For some reason, the parent form gives me an error if any two participants have any of those fields in common.  That is to say: if two participants are sponsored by the same society, or if they work in the same institution, the parent form throws an error when I attempt to submit it.

None of the fields are set to demand unique values. (Is that even a thing that can be done on a Lookup field?)  If I go to the subform directly and complete it outside of the parent form, it saves fine even if the sponsor or institution values match another record already saved.

I've sent a request to support for this, but I wondered if anyone else has run into it.  Is there an explanation (or better yet, a fix) that I'm not seeing?




                            Zoho Desk Resources

                            • Desk Community Learning Series


                            • Digest


                            • Functions


                            • Meetups


                            • Kbase


                            • Resources


                            • Glossary


                            • Desk Marketplace


                            • MVP Corner


                            • Word of the Day



                                Zoho Marketing Automation


                                        Manage your brands on social media



                                                Zoho TeamInbox Resources

                                                  Zoho DataPrep Resources



                                                    Zoho CRM Plus Resources

                                                      Zoho Books Resources


                                                        Zoho Subscriptions Resources

                                                          Zoho Projects Resources


                                                            Zoho Sprints Resources


                                                              Qntrl Resources


                                                                Zoho Creator Resources


                                                                  Zoho WorkDrive Resources



                                                                    Zoho Campaigns Resources

                                                                      Zoho CRM Resources

                                                                      • CRM Community Learning Series

                                                                        CRM Community Learning Series


                                                                      • Tips

                                                                        Tips

                                                                      • Functions

                                                                        Functions

                                                                      • Meetups

                                                                        Meetups

                                                                      • Kbase

                                                                        Kbase

                                                                      • Resources

                                                                        Resources

                                                                      • Digest

                                                                        Digest

                                                                      • CRM Marketplace

                                                                        CRM Marketplace

                                                                      • MVP Corner

                                                                        MVP Corner

                                                                      





                                                                      




                                                                          Design. Discuss. Deliver.

                                                                          Create visually engaging stories with Zoho Show.

                                                                          Get Started Now