Display data from two masters within a single data grid
I would like to display information from two data masters within a single data grid.
For example: I'm dealing with tasks related to a vehicle. The vehicle information (make, model, description, etc.) is contained within one data master "vehicles" while the task information (title, due date, assigned to, etc.) is in a second data master "Tasks". The "related to" field from the tasks keys to the "description" field from vehicles.
I would like the data grid to display the list of tasks with some information about the vehicle the tasks relates to.
If necessary I could load a second data grid within the main one just for those fields but that would limit field placement and I'd like to avoid it.
Is this possible?