I'm trying to match companies based on countries in which they operate. If Company A operates in "Australia, Germany", I'd like the list of other (multiple) companies that also operate in "Australia, Germany".A select statement matching single values...

I'm using an update-only table, where the user selects the record to be updated. When I attempt to save, a "key value is required" error message is returned. Other values I can LOOKUP when the record is selected. I can't add a LOOKUP formula to a key...