I'm sure this has been asked many times, but I can't seem to turn up an applicable solution...
I have a workbook with tables on separate worksheets:
Sheet named "CompanyData" has a (formally designated) table named "Companies" that includes a data field named "CompanyID". There is one record...