Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Figuring out fields that join tables

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Zeke
Basic Member
Posts: 6
Basic Member
11/5/2010 5:21 PM
    Does a magic bullet exist for figuring out the fields that join tables together in Lawson?  I am familiar with the ERDs available on this site, dbdoc, and derfldrpt, but what about the actual fields that need to be related together to retrieve unique results?

    I assume the answer is just to figure it out yourself or learn how to read the output from dbdoc better, but I wanted to make sure we weren't missing something obvious.
    John Henley
    Posts: 3353
    11/5/2010 7:21 PM
      It's mostly looking at the relationships maintained by Lawson, and understanding how Lawson does conditional indexes.
      Thanks for using the LawsonGuru.com forums!
      John
      mark.cook
      Veteran Member
      Posts: 444
      Veteran Member
      11/8/2010 12:07 PM
        One other option if you are new to Lawson tables, is to use the OLEDB connector to help see the tables and relationships. That connector is too slow for all your reporting needs but will give you an idea how to link the tables together.