Index: trunk/ippMonitor/def/detProcessedExp.d
===================================================================
--- trunk/ippMonitor/def/detProcessedExp.d	(revision 12835)
+++ trunk/ippMonitor/def/detProcessedExp.d	(revision 13264)
@@ -1,14 +1,30 @@
-TABLE detProcessedExp
+TABLE detProcessedExp, rawExp
 TITLE detProcessedExp
 FILE  detProcessedExp.php
 MENU  ipp.detrend.dat
 
-#     field     size   name       show            link to                 extras
-FIELD det_id,     7,   Det ID,    value
-FIELD exp_tag, 	 15,   Exposure,  value
-FIELD *, 	  8,   image,     image=$path_base@PPIMAGE.JPEG2,  detProcessedImfile.php, det_id=$det_id,exp_tag=$exp_tag,image=$path_base@PPIMAGE.JPEG1
-FIELD bg, 	  8,   backgnd,   value
-FIELD bg_mean_stdev, 8, [stdev],  value
-FIELD bg_stdev,   8,   stdev,     value
-FIELD recipe,    15,   Recipe,    value
-FIELD path_base, 20,   path_base, none
+# the following WHERE clauses are added to all queries joined by AND
+WHERE detProcessedExp.exp_tag = rawExp.exp_tag
+
+# define image names to be used below
+# IMAGE VAR basename filerule camera class_id
+IMAGE JPEG2 $detProcessedExp.path_base PPIMAGE.JPEG2 $rawExp.camera NONE
+
+ARGS  ARG1 det_id=$detProcessedExp.det_id
+ARGS  ARG1 exp_tag=$detProcessedExp.exp_tag
+ARGS  ARG1 camera=$rawExp.camera
+ARGS  ARG1 basename=$detProcessedExp.path_base
+
+#     field                    size    	name       show          link to                 extras
+FIELD detProcessedExp.det_id,     7,   	Det ID,    value
+FIELD rawExp.camera,             10,    camera,    value
+FIELD detProcessedExp.exp_tag, 	 15,   	Exposure,  value
+FIELD *, 	  		  8,   	image,     image=JPEG2,  detProcessedImfile.php, ARG1
+FIELD detProcessedExp.bg, 	  8,   	backgnd,   value
+FIELD detProcessedExp.bg_mean_stdev, 8,	[stdev],   value
+FIELD detProcessedExp.bg_stdev,   8,   	stdev,     value
+FIELD detProcessedExp.recipe,    15,   	Recipe,    value
+FIELD detProcessedExp.path_base, 20,   	path_base, none
+
+# note: you must include all desired fields, where ever they are used,
+# in FIELD