hello,

Actually I want to get a diagram of the tables' relationship in baan database and on this group i came across that there is some inbuilt method in some session to generate such a diagram...so can anybody please tell me the session id for that session in Baan V?...it will help me a lot in understanding the the structure of the baan database...hope to get the help in this regard,

thanks in advance,
regards,
Dilip.

Hi,

Check the following links:
http://baanboard.com/baanboard/showthread.php?t=25328&highlight=diagram
http://baanboard.com/baanboard/showthread.php?t=16842&highlight=diagram

I hope it helps,

- George

dear george,

thanks a lot for your time and consideration...but i am sorry i could not find that session and id (ttadv4131m000) in Baan V any where that was there on the link given by you(dont know why...if it should b...:-( )..plz help me...is ther some other way to ido it...plz give me the alternate of it...expecting the help again,
thanks in advance,
regards,
dilip.

From the other threads it looks like that session is not available in Baan 5. You can always write a program to parse the data dictionary. You can always try printing the table definition ttadv4420m000 (if available) and working with the table in questions. I am sure there are probably some 3rd party products to map the tables out, but I am not aware of them.

To learn the tables I recommend first just printing the table layouts. Once you have that you can start looking at what links to what. You can always write a quick query against ttadv422(table fields - what it is called in Baan IV) to get the relationships between the tables.

Keep in mind that not everything is restricted by database rules. Somethings are enforced in the coding of the programs.

actually i was puzzled becuase i could not find the session id given in on thread..thanks a lot mark for making me clear in this regard...now i will follow the way you hav described...thanks again,

regards,

Dilip.