Missing records when using 2 tables
Posted on 2002-03-12
Using  Foxpro tables to build report. Grouping on GLACMST.GLNO yields ALL GLNOs as expected. When I add details (the GLNO fields in each table are indexed and linking properly) from the second table NONE of that data displays--if I format the section to [Suppress blank section] it IS suppressed.
I've built this several different ways: when pulling in the GLTRMST table first and using GLNO from that table all the data from both tables displays in the Details section ok...but I need to show ALL GLNO from the GLACMST table-which is the complete list. The second table shows active transactions so not all GLNOs will have records from that table.
Sooo...how do I keep the report grouped on GLACMST.GLNO, and pull in the additional info from the GLTRMST table??