# Problem in Fetching Value from another table
**URL:** https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742
**Category:** Technical Forum
**Created:** [October 9, 2012, 7:19am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742 "2012-10-09T07:19:25Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@SMohan](https://www.dynamicsuser.net/u/SMohan)
#### Post date: [October 9, 2012, 7:19am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742/1 "2012-10-09T07:19:25Z")
Hi Experts,
I created a new table “Purchase Requisition” and in that there are two fields which are correlated they Department Code and Department Description those fields are fetching from same table Dimension Value.
1. I am fetching Value of Department Code field from Dimension Value "Code " only where Dimension = Verticals and Department Code value is fetching properly there is not any problem.
2.But when i tried for fetching for “Department Description” which should be same name of the “Department Code” but its not coming i also tried Flow Field to get this value but Flow filed is displaying value when i close the table or refreshing navision please guide me.
---
### Author:  [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)
#### Post date: [October 9, 2012, 7:22am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742/2 "2012-10-09T07:22:39Z")
How did you fetch the Department Code?
Can you show us the code?
---
### Author:  [@SMohan](https://www.dynamicsuser.net/u/SMohan)
#### Post date: [October 9, 2012, 7:28am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742/3 "2012-10-09T07:28:18Z")
I am fetching Departement code through set the following property in table relation
“Dimension Value”.Code WHERE (Dimension Code=FILTER(=VERTICALS))
---
### Author:  [@SMohan](https://www.dynamicsuser.net/u/SMohan)
#### Post date: [October 9, 2012, 7:35am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742/4 "2012-10-09T07:35:18Z")
My problem is that i couldn’t getting the value from “Department Description” when i select “Department Code”…
---
### Author:  [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)
#### Post date: [October 9, 2012, 7:38am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742/5 "2012-10-09T07:38:18Z")
So do you select from Lookup in Departement code?
---
### Author:  [@SMohan](https://www.dynamicsuser.net/u/SMohan)
#### Post date: [October 9, 2012, 7:48am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742/6 "2012-10-09T07:48:56Z")
Yes i can select Department Code from LookUp
---
### Author:  [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)
#### Post date: [October 9, 2012, 7:52am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742/7 "2012-10-09T07:52:27Z")
Then write code on “Department Code” validate trigger
CALCFIELDS(“Department Description”);
---
### Author:  [@SMohan](https://www.dynamicsuser.net/u/SMohan)
#### Post date: [October 9, 2012, 8:00am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742/8 "2012-10-09T08:00:23Z")
YA!!!
Its working thanks a lot for Help Have Nice Day [;)]
---
### Author:  [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)
#### Post date: [October 9, 2012, 8:18am UTC](https://www.dynamicsuser.net/t/problem-in-fetching-value-from-another-table/40742/9 "2012-10-09T08:18:48Z")
Welcome [:)]