Who's On?

	Membership:
	Latest: HireIQ
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5264

	People Online:
	Visitors: 430
	Members: 0
	Total: 430

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Figuring out fields that join tables

2 Replies

0 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

Zeke

Basic Member Send Private Message

Posts: 6

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: 3351

11/5/2010 7:21 PM

It's mostly looking at the relationships maintained by Lawson, and understanding how Lawson does conditional indexes.

mark.cook

Veteran Member Send Private Message

Posts: 444

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.