We tried to upgrade DBFront from 22.214.171.12451 to the latest. The installation went fine, but we got the following error on some tables:
"Can't load lookup data for [foreign key] - Value can't be null"
In a lot of cases where we didn't have lookup tables previously, we added them so that DBFront could generate dropdown tables for acceptable values. We did this in a quick and non-standard way - we left the values in the main table as is, got a distinct list of values, and created a new lookup table with this list. One of those values (for a number of tables) was null, which I assume is causing the problem above.
Is there a quick fix for this on your end (since this worked before), or will we need to create IDs and more proper lookup tables?