it successfully works on pulling data from our ERP system (Efacs).  I have now added a link to an Access Database.

 

On a table called tbl_daily_Despatch_entries there are two fields called Weight & Dimensions

 

i want to add these fields to the invoice.  I have added them in and got a link for the invoice no (Efacs dbo.delv.delvno) on to the access table under visual linking expert.

 

in the field on the report template, I can "Browse Data" ok and i get the Correct Data.

 

when i print the specific invoices out (that have data in the Access datbase), i get BLANK fields for Weight and Dimensions

 

not sure what i am doing wrong ???

 

can anyone offer any advice.

 

for Extra Information:-

My Crystal Version is 7

My MS Office (access) version is 2003

and i am running Windows XP

 

look forward to any comments

regards

Paul_Birm