'SYS08 Employee Details'.Region

Wade

I'm having a little difficulty in the exam on activity 6.  I understand the sum that needs to be completed on region and role, however I am having difficulty updating the region on the SYS08.  Am I going down the wrong path or how should I think about updating this region in the module?

 

Thanks, 

JaredDolich

@Wade 

So close! Just to add to @einas.ibrahim query. In the SYS08 module you were asked to add a line item called Region. Since you already know the country of the employee then you can easily determine the region using the function PARENT(). Parent(Country) .

The system module is used like a lookup table. In this way, you don't need to add the Region to your module that has all the data in it because it would just repeat the region unnecessarily and take up space.

Give it another try. I think you've got this.

 

einas.ibrahim

Hello @Wade 

 

Tell me again please, why do you need to update the regions in the first place? 

Wade

Thank you I should have known it would be something simple.