I would like to report off of the Maximizer 7 database. When I connect via ODBC I do not see any of the MAX files available. Is there are way to access these files so that I can use Crystal Reports?

I can see the tables using the ODBC driver and I'm also using Crystal Reports 8.5. My problem is that I don't know how to relate the tables (i.e. "link" them in Crystal).

Does anyone have a relation diagram?

-Jeff

Just your regular OCBC connetion will gain you access to the tables. If your using Pervasive you will have to use the pervasive views because you can't hit the table directly. SQL is easy though, keep in mind SA wont work use the MASTER user or another authenticated Max User. All reg tables are linked by Client_ID and Contact_Number, opp related are Opp_ID and Opp_number. Good Luck.