need to have cascading master detail tables sqlite3[solved] lazarus / 16-Databases ---------------------------------------------------------------------- davesimplewear · 2010-09-26 02:19 I have one table connected to a master table then I need to run a list off the detail table as another detail table, when I open the second detail table I get an access error, photos of table setup attached. Regards Dave ---------------------------------------------------------------------- LuizAmérico · 2010-09-26 09:15 please, post a small test program ---------------------------------------------------------------------- davesimplewear · 2010-09-26 21:39 I do not know what is happening, made a test program, when setting the tables up got an access violation, then run the program and everything worked, same setup as posted previously. Go figure, I can't duplicate the error, thanks Luiz. Regards Dave