When I first designed my project, I had three tables in Master-Detail relationships (tng_aCourse->tng_CourseSession->tng_SessionAttendance). After some experimenting, I decided to elimiate the middle table and just have the SessionAttendance table directly under the aCourse table. However, when I go to the list on aCourse and click on the Details link, I keep getting an error as it is still looking for CourseSession table.
I have already:
<ol>
Removed the table in MariaDB and removed any Foreign Key that referred to that table
Sync'd the DB in PHPR
Checked the SQL statement on all tables in the project
Removed and recreated the detail link in the tables page in PHPR
Removed the detail link on the List page for aCourse in the Designer and recreated it with SessionAttendance.
</ol>Any idea what I am missing that is causing the application to continue to refer to this table that has been long removed? I'm pulling out the little hair I have left trying to find any reference to the deleted table.