I have 2 tables - Orders and Jobs
Jobs have reference to the Orders.
Now I want to get the value from the " Production Status " Column from Jobs Table in a Virtual Column in a Orders . How do I do that ? I know I can add a column in my data source referring the Jobs and get the value using [Jobs].[Production Status] but I dont want to add an extra column in my database unnecessary . Is there another way out ?
In Detail, I am able to render the status using the inline views but I want in the main view ( ORDER LIST VIEW) and I also want to be able to filter the orders based on the production status.