Foreign Key is not showing up in dbFront

Question

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.

Answer 1

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.