What is best method to link or lookup tables with encrypted fields.

What is best method to link or lookup tables with encrypted fields.

I am testing out Zoho Creator for making a HIPAA database to keep track of patients and their appointments. I have two tables: Patients and Appointments that I would like to be related as one-to-many (one patient can have many appointments). 

Per these instructions, I have encrypted the fields in the Patient table that contain identifying ePHI (name, date of birth, etc). However, when I then go to set up a lookup field in the Appointments table to link the tables, these encrypted fields no longer show in the dialog for setting up the lookup field. The lookup field does show non-encrypted fields like ID as options to set the relationship, but this is essentially a random number with no relevance to the patient making it hard to know if you are selecting the correct patient when setting relatoinships in the app.

Has anyone encountered this problem and can recommend a work-around for linking tables with encrypted fields?

    Zoho Pagesense Resources

        Zoho SalesIQ Resources



              Zoho TeamInbox Resources

                Zoho DataPrep Resources


                    Zoho CRM Plus Resources

                      Zoho Books Resources


                        Zoho Subscriptions Resources

                          Zoho Desk Resources

                            Zoho Projects Resources


                              Zoho Sprints Resources


                                Qntrl Resources


                                  Zoho Creator Resources


                                    Zoho WorkDrive Resources




                                        Zoho Campaigns Resources

                                          Zoho CRM Resources

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now