Fixed: Lookup Details not displayed after foreign-key created

Question

I added a new foreign key to a table and I can see the table in the table manager so dbfront has permissions to the table but the lookup details doesn't display in the field. I've removed the FK and readded it, removed the tables and readded them, nothing seems to work. What could I be missing?

Answer 1

As of dbFront 1.2.2.2792, dbFront now correctly handles renamed/dropped fields that appear in lookups.

Previously it was determined that renaming a primary key or other column on a lookup table could cause dbFront to get confused and reject the relationship going forward due to the presence of now old invalid configuration.

This issues is now fixed.

If you ever encounter issues with relationships it is good to open the Log Viewer and search for the word "Relationship". dbFront should log any details there.