--- a/fhiiqm/form/ma_fkt_form.inc.php	Fri Oct 14 15:37:47 2011 +0200
+++ b/fhiiqm/form/ma_fkt_form.inc.php	Fri Nov 04 11:18:11 2011 +0100
@@ -27,7 +27,7 @@
         <tr><td>Funktion *</td>
             <td valign="top">
                 <!--<input class="long20" type="text" name="fkt[func]" id="func" value="<?php echo $fkt['func']; ?>"/> -->
-                <select name="fkt[func]">
+                <select name="fkt[func]" onchange="this.form.submit();">
                 <?php 
                     $sql = "SELECT fkt_bez, fkt_ID FROM `fhiiqm`.`Funktion` ORDER BY 1";
                     if ($result = $dbc->queryObjectArray($sql))
@@ -45,7 +45,46 @@
             </td>
         </tr>
         <tr><td>Geltungsbereich</td>
-            <td valign="top"><input class="long20" type="text" name="fkt[ber]" id="ber" maxlength="50" value="<?php echo $fkt['ber']; ?>"/>
+        <td valign="top">
+        <?php
+            if (isset($fkt['func']) && $fkt["func"]=='AL')
+            {
+                echo "<select name='fkt[ber]'>\n";
+                $sql = "SELECT  abt_ID,abt_name,abt_long FROM `fhiiqm`.`Abteilung`";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->abt_name == $fkt['ber'])
+    					   echo "<option selected value=\"$row->abt_name\">$row->abt_name</option>\n";
+    				    else
+    					   echo "<option value=\"$row->abt_name\">$row->abt_name</option>\n";
+                    }
+                }
+                echo "</select>";
+            }
+            elseif (isset($fkt['func']) && $fkt["func"]=='AGL')
+            {
+                echo "<select name='fkt[ber]'>\n";
+                $sql = "SELECT ag_name, abt_name FROM `fhiiqm`.`Arbeitsgruppe` ag INNER JOIN fhiiqm.Abteilung a
+                        ON ag.abt_ID=a.abt_ID ORDER BY ag.abt_ID, ag_ID";
+                if ($result = $dbc->queryObjectArray($sql))
+                {
+                    foreach ($result as $row)
+                    {
+                        if ($row->ag_name == $fkt['ber'])
+    					   echo "<option selected value=\"$row->ag_name\">$row->ag_name, $row->abt_name</option>\n";
+    				    else
+    					   echo "<option value=\"$row->ag_name\">$row->ag_name, $row->abt_name</option>\n";
+                    }
+                }
+                echo "</select>";
+            }
+            else
+            {
+        ?>
+            <input class="long20" type="text" name="fkt[ber]" id="ber" maxlength="50" value="<?php echo $fkt['ber']; ?>" onfocus="this.select();"/>
+        <?php } ?>   
             </td>
         </tr>
         <tr><td>Beginn</td>