I don't know what version of Crystal Reports is used by ACCPAC, so it's a bit difficult to help as how this is done can vary by version.
You'll need to link the tables to filter them via the Selection Expert.
>Thanks for your help Craig,
>
>Actually, I'm using the version of Crystal reports for ACCPAC. They added this module called "Service Manager" I think, to produce work orders. I'm modifying the work order report.
>
>I was able to add the table thru the "Database" something I think(menu), and like you mention it creates the link automatically but after I go back the link is gone, then I try to link by drag and drop but it doesn't take. I'm thinkin maybe the tables are from different databases or servers and that's why it won't allow to link.
>
>One thing that I noticed is that when I added the table I had to go to a connection and login to SQL Server to get the list of tables. I thought it would should the connection that the existing tables are using, but it doesn't. How do I see which connection the existing tables are using?
>
>Another problem is that even if I get the link to take I still need a second filter on that table, how do I do that?.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer