A complete listing of Sage BusinessWorks tables and fields, including linked fields is available on the Sage BusinessWorks News Web site.

1. From the Sage BusinessWorks Welcome screen, click Sage BusinessWorks News

2. Select the Features sheets

3. Select File Formats

The information in the tables and fields can be used to create a Crystal Report or query the database from Excel.

If you need additional  assistance with creating a Crystal Reports please contact Sage BusinessWorks at (800) 447-5700, select option 1 for Client Care. Ask for a list of Sage Business Partners in your area to assist with the Crystal Reports.

A complete listing of Sage BusinessWorks tables and fields, including linked fields is available on the Sage BusinessWorks News Web site.

1. From the Sage BusinessWorks Welcome screen, click Sage BusinessWorks News

2. Select the Features sheets

3. Select File Formats

The information in the tables and fields can be used to create a Crystal Report or query the database from Excel.

If you need additional  assistance with creating a Crystal Reports please contact Sage BusinessWorks at (800) 447-5700, select option 1 for Client Care. Ask for a list of Sage Business Partners in your area to assist with the Crystal Reports.

I am trying to see if these tables can be linked on primary table and if so what join, or do they have to be done by subreport, Everything I have tried keeps duplicating the lines which normally means you have wrong links and joins.

mwb-  If you have any questions on linking tables, I would have you call our support team at 800-447-5700 to discuss your options.  Or I would have you contact Sage BusinessWorks at (800) 447-5700, select option 1 for Client Care. Ask for a list of Sage Business Partners in your area to assist with the Crystal Reports.