[resolved] 3 tier master child - TDBGrid show wrong rows in 3rd tier lazarus / 31-LCL ---------------------------------------------------------------------- Michael Collier · 2011-09-21 05:08 I'm assunming the master-child relations should work the same in lazarus as they did in Delphi, here is the result I get that seems wrong, could someone please confirm. Create 3 tables with master child relation:   GrandParent  <--- Parent  <---Child Create lazarus form with 3 TDBF components and configure the master fields as normal. When there is data in **all** the tables, scrolling through Grandparent correctly shows Parent & Child rows. BUT - Scroll to a Grandparent when the parent table has no rows, the child table doesn't clear itself, instead it keeps displaying data for the previous viewed grandparent. ---------------------------------------------------------------------- JD · 2011-09-21 08:33 That is not a Lazarus issue. I don't know what components you are using but I know that what you are doing works for me when I use Zeos in Delphi AND in Lazarus. I suggest that you look carefully at how you defined the Master-Child relationships in the properties of the components and in addition, verify that the datasource of your problematic TDBGrid is the correct one. ---------------------------------------------------------------------- Michael Collier · 2011-09-22 15:27 Thanks, I'm using TDBF components, using a database server is out of the question for this particular application so TDBF has to work for me. I have just produced a small Delphi test application using the DBDemos tables - Client Holdings Master In Delphi the scrolling of records behaves as one would expect, in Lazarus I get the error I described. The setting of table names, index field names, masterfields and master source are exactly the same in both applications. ---------------------------------------------------------------------- JD · 2011-09-24 13:56 Quote from: Michael Collier on September 22, 2011, 05:27:45 pmThanks, I'm using TDBF components, using a database server is out of the question for this particular application so TDBF has to work for me. I have just produced a small Delphi test application using the DBDemos tables - Client Holdings Master In Delphi the scrolling of records behaves as one would expect, in Lazarus I get the error I described. The setting of table names, index field names, masterfields and master source are exactly the same in both applications. Send a sample of this project as an attachment so we can test on our systems. ---------------------------------------------------------------------- Michael Collier · 2011-09-26 11:01 Thanks JD, uploaded to my wesbite http://www.lazdev.net23.net/download/dbftest_3tier.zip ---------------------------------------------------------------------- Michael Collier · 2011-09-29 09:30 will try something else, thanks anyway