Relationship between Company and Department Table

[anubhavkapoor76]

Hi All,

Where does the relationship between Company ( core_company) and Departments ( cmn_department) table exist?

Assumption: Department field gets autopopulated on filling the Company field

[Pradeep Sharma · Accepted solution]

Hi Anubhav,

"cmn_department" table has a field "company" that refers to the company table. Most likely there could be a client script in your instance which is auto-populating the Department field.

- Pradeep Sharma

[anubhavkapoor76]

That's correct!! I just saw that....there is no client script that is filling it and I presume it was done first time when User Data was loaded.

Thanks Pradeep

[Pradeep Sharma]

You are very welcome. Let me know if that answered your question. If so, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

[anubhavkapoor76]

The reference field of company in cmn_department table does not populate any value)