Submitted by Alp on 2019/11/26 20:04
Hi,
 
I am trying to prepare a dropdown list, "NewField", in a Grid5 with which I want to pull values from four other grids' Item's, by making use of the following query. I checked "Save all listed fields." However, I couldn't get it to work. Is it an invalid combination or am I missing a step?

SELECT Item as NewField from (Grid1 OR Grid2 OR Grid3 OR Grid4)

Thanks,
Alp

Comments

Hi,
 
This isn't valid SQL syntax... why not use one of:
  • create a grid which shows all items in the 4 other grids
  • create a field which combines source of the 4 grids and base the dropdown on that field
 
Pierre_Admin
IQ Designer