Hello!
I have three tables:
Table 1 : ProfitCenters
| ID (key) | ProfitCenter (label) |
|---|
Table 2 : Project
| ID(key) | Description | Project_ProfitCenter (Ref to ProfitCenters) |
|---|
Table 3: Request
| ID(Key) | Description | ProjectID (ref to Projects) | ProjectProfitCenter |
|---|
Projects ref to ProfitCenters and Request Refs to Projects.
I was using [Project].[Project_ProfitCenter] to auto enter the profit center from the Projects table but the return value is the ID rather than the label in the Request table. I know I need to deference to the original table but I’m not understanding how to get that value. I tried ProfitCenters[ProfitCenter] but that is a list and I only need to return the text value of profit center associated with the Project.