Hi,

 

I'd like to combine two grids with a common field under a new grid that self-populates all items without any need for my interaction. My "grid: fields" are
 

stores: item (holding storeid), storenames, city
employees: item (holding employeeid), storeid, employeenames

I can transfer storenames and city fields from stores grid into employees grid through the following SQL query under a new field 'storecode': "Select Item as storecode, storenames, city from stores". However, this way, I need to select store names for every employee one by one myself. With hundreds of employees, this is not feasible.

Is there a way that I can combine fields of these two grids under a third grid making use of their common field, i.e., storeid, without my interaction for each item?
 

Thanks,

Alp