We are using Maximizer Enterprise 9.5 SQL and I have a need to generate Crystal Reports that acquire data from both the Notes associated with Address Book as well as Documents. I have no problems accessing the Notes data from AMGR_Notes_Tbl but see no equivalent table for Documents. The desired result is to list the number of emails, *.pdfs, *.xls, *.doc files have been inserted against a specific Address Book Company or Contact during any measurement period and who by. I have no need to access text or data from within the attached file, I just need to access the column data listed such as Date, Type, Text and Creator.
Any suggestions would be most welcome.
Thanks
Original Post