Menu

Fixed: Lookup Details not displayed after foreign-key created

0 votes

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?

in Version 1.1.5 by (490 points)
edited by

1 Answer

0 votes

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.

by (60.2k points)
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...