Is there a way to allow a user to input their name on a form but that field checks against a master table already containing their name?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I will have a master table of all clients, another table/form that is an assessment that the client will have to completed. I want to have a relationship between the master table and the assessment table via the name field, but It cannot be a drop down as we do not want clients to see each other's name.
Photo of Neal

Neal

  • 100 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Harrison Hersch (MCF)

Harrison Hersch (MCF), Champion

  • 40 Points
Hey Neal. You could in theory do what you are asking, but it would have to match exactly. Also, this would not actually prevent a savvy user from getting to the data behind the scenes. What you might want to do instead is setup an advanced security model so that users are associated to a company and therefore can only see specific records.