Ok, figured it out. I did not do anything wrong in how I set it up. I was writing to the test server then trying to read it from the production server. Ha Ha.
In the meantime I had rewritten it with SQLite and that works too. More than one way to do these things you know.
If anyone else is curious, here are the steps to create a database table lookup.
Under “Site Options…”, “Database Configurations”, Build your DB connection.
Under “Database Schema Configurator” pick out the table you will want to use. {Not sure that’s necessary, but I did it}
Under “Lookup Table Configurator”, “Basic Database Lookup”, Pick your database Connection, Table, and Column(s) for inbound and Column(s) for outbound.
Save and use like a table lookup! If you don’t mismatch TEST and PROD then it works.
