* A preselection Grid is used for sea and land resources * In practicity it's vital to keep sea and land resources separated * Data is highly different * Grid is something like : Latitude,Longitude,Location type,Height/Depth,Chemical 36.2553N, 26.7832E, Sea, 70, oPO4 37.1253N, 30.1345E, Land, 150, Fe++ * Now here Lat/Long data is in one table * User cannot change Location (preknown) * Measurements done there are classified with height or depth * User also cannot change height/depth and chemical but choose from combos * 4 combos are like : * 1- cmbHeights select height from landlocs ; * where latitude=locs.latitude ; * and longitude = locs.longitude ; * into cursor hgtList * 2- cmbDepths * select height from sealocs ; * where latitude=locs.latitude ; * and longitude = locs.longitude ; * into cursor depthList * 3- cmbSeaChemicals * select chemname from sealocs ; * where latitude=locs.latitude ; * and longitude = locs.longitude ; * and dMeasured = thisform.dChems ; * and depth = this.parent.parent.HgtDpthCol.cmbDepths.value ; * into cursor chemlist1 * 4- cmbLandChemicals * select chemname from landlocs ; * where latitude=locs.latitude ; * and longitude = locs.longitude ; * and dMeasured = thisform.dChems ; * and height = this.parent.parent.HgtDpthCol.cmbHeights.value ; * into cursor chemlist2 * 1 and 2 are in column HgtDpthCol, 3 and 4 are in ChemsCol column. * Where needed, columns requery is called. * ...HgtDpthCol.Dynamiccurrentcontrol = ; * iif(locs.loctype = "Sea","cmbDepths","cmbHeights") * ...ChemsCol.Dynamiccurrentcontrol = ; * iif(locs.loctype = "Sea","cmbSeaChemicals","cmbLandChemicals")Cetin