Sage 100

I have a customer asking if Sage 100 Premium supports Database Diagrams through SQL? I believe the answer to this is now. The customer wanted to look at a visual representation of the links. I pointed them to the File Layous ( online ) but wanted to double check to be sure I haven't overlooked some way to create this functionality in SQL.

------------------------------
Wayne Schulz
wayne@s-consult.com
Schulz Consulting
(860) 516-8990
Moodus, CT
------------------------------

Well, you can create diagrams, but Sage 100 doesn't really seem to use the foreign keys concept, so it doesn't look like the automation part will work ("add related tables" was grayed out for all the tables I tried as starting points).  Sage 100 uses SQL as if it were another flat file storage medium.  It doesn't actually take advantage of all that SQL can do.

------------------------------
Phil McIntosh
Friendly Systems, Inc.
------------------------------