Subject Re: function form_onNavigate(nWorkArea) From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Wed, 12 May 2021 22:38:56 +0530 Newsgroups dbase.getting-started Good Evening Roy, > Mystery solved.... > In setting up different directories for testing , (Causing confusion) my > Form's SQL for that file was selecting the wrong directory, where the > table still had the character field. > Changing to the correct directory, makes the relationship works to bring > up the correct record as it did in the test Form. > I found my mistake when I changed one of the records, but the change was > not shown when running the form > Apologies for my wasting your time. You are definitely not the first one to be doing this. And others will be following you probably. I have also done this before. So do not waste time thinking about this. Regards Akshat