Home Forums General Issues Relationship query help Reply To: Relationship query help

  • While that makes perfect sense, it works if I am only doing a zipcode search. Unfortunately my search is actually using multiple custom fields beyond just zipcode (and thus which location IDs). Users can do a search for a Dentist in a zipcode, so I also have to match a custom field where a doctor has that specialty assigned to them as well. In doing so, I have to make “relation” an “AND” statement, your code requires it be an “OR” statement.

    Looks like I will have to do a completely custom SQL statement for this.