Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 51
	Members: 0
	Total: 51

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

Figuring out fields that join tables

2 Replies

0 Subscribed to this topic

23 Subscribed to this forum

Sort:

Author

Messages

Zeke

Basic Member

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

New Poster

Engaged Reader

Avid Reader

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

Posts: 444

New Poster

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.