You are trying to retrieve all rows from both tables? Sounds interesting. You'll likely be getting tons of non-matches, which leaves lots of null fields, making working with the data set rather interesting. Would you be willing to share the query so that we can have a better idea what is happening?

When querying a DB using Crystal Reports, the work it done by the Workstation, no the Server.
That is why Data Servers have "Views" ( Or Pass-Through Queries in MS Access).
 
Dont know exactly what type of info you are trying to get, but I suggest you start creating Views in Pervasive. These "Views" are seen by Crystal as Tables.
 
If you are planning to Link BKGLTRAN with BKAR* create a view:
 
SELECT  
BKGL_TRN_GLACCT,
BKGL_TRN_GLDPT,
BKGL_TRN_DATE,
BKGL_TRN_CODE,
BKGL_TRN_INVC,
CONVERT (LTRIM(BKGL_TRN_INVC), SQL_DOUBLE) AS INV,
BKGL_TRN_DESC,
BKGL_TRN_DC,
BKGL_TRN_AMT  
FROM BKGLTRAN
WHERE BKGL_TRN_DATE >= '2006-04-01' AND BKGL_TRN_DATE <= '2007-04-30'  
AND BKGL_TRN_TYPE = 'RS' AND BKGL_TRN_GLDPT = 'SAT'
 
 
Remember that the column that has the "Invoice" (BKGL_TRN_INVC) is a Char and the "Invoice" info on  
BKARHINV (BKAR_INV_NUM) is a DOUBLE.
 
You can not link them via SO Number.
 
The query to link the two BKAR* tables is:
 
SELECT  
BKARINV.BKAR_INV_NUM,  
BKARINV.BKAR_INV_SONUM,  
BKARHINV.BKAR_INV_NUM
FROM BKARINV LEFT JOIN BKARHINV ON (BKARINV.BKAR_INV_SONUM = BKARHINV.BKAR_INV_SONUM) AND (BKARINV.BKAR_INV_NUM = BKARHINV.BKAR_INV_NUM)
ORDER BY BKARINV.BKAR_INV_NUM
 
Good Luck,
 
Kelloggs
 
 

If a Sales Order has been fully shipped is not on BKARINV
 
Ask NovaZyg, he will tell you how these two tables interact
 
Regards,
 
Kelloggs