Figuring out fields that join tables

Sort:
You are not authorized to post a reply.
Author
Messages
Zeke
Basic Member
Posts: 6
Basic Member
    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
    Senior Member
    Posts: 3348
    Senior Member
      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
        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.
        You are not authorized to post a reply.