Foreign Key is not showing up in dbFront

0 votes

I changed a foreign key on 3 columns from one table to another table and now they no longer show up as foreign keys. I tried refreshing and waiting but I can't get dbFront to show or use the new foreign key.

in Errors by (7.0k points)

1 Answer

0 votes
Best answer

The most likely issue is that dbFront does not have access to the new table that you are using as your lookup table. If dbFront does not have access to a table then it won't show any of the relationships connecting to that table.

To check this open the Manage Tables tab on the Connection Access dialog for that database connection. For more details see: Manage Tables. If the lookup table is not present then dbFront won't show it.

by (64.4k 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