• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Figuring out fields that join tables

 2 Replies
 0 Subscribed to this topic
 24 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: 3366
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
New Poster
New Poster
Congrats on posting!
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.