+ $sth->finish;
+
+ $query =
+ qq|SELECT count(id) = 0 AS orphaned
+ FROM parts
+ WHERE buchungsgruppen_id = ?|;
+ ($form->{orphaned}) = selectrow_query($form, $dbh, $query, $form->{id});
+ }
+
+ $query = "SELECT inventory_accno_id, income_accno_id, expense_accno_id ".
+ "FROM defaults";
+ ($form->{"std_inventory_accno_id"}, $form->{"std_income_accno_id"},
+ $form->{"std_expense_accno_id"}) = selectrow_query($form, $dbh, $query);
+
+ my $module = "IC";
+ $query = qq|SELECT c.accno, c.description, c.link, c.id,
+ d.inventory_accno_id, d.income_accno_id, d.expense_accno_id
+ FROM chart c, defaults d
+ WHERE c.link LIKE '%$module%'
+ ORDER BY c.accno|;
+
+
+ my $sth = $dbh->prepare($query);
+ $sth->execute || $form->dberror($query);
+ while (my $ref = $sth->fetchrow_hashref(NAME_lc)) {
+ foreach my $key (split(/:/, $ref->{link})) {
+ if (!$form->{"std_inventory_accno_id"} && ($key eq "IC")) {
+ $form->{"std_inventory_accno_id"} = $ref->{"id"};
+ }
+ if ($key =~ /$module/) {
+ if ( ($ref->{id} eq $ref->{inventory_accno_id})
+ || ($ref->{id} eq $ref->{income_accno_id})
+ || ($ref->{id} eq $ref->{expense_accno_id})) {
+ push @{ $form->{"${module}_links"}{$key} },
+ { accno => $ref->{accno},
+ description => $ref->{description},
+ selected => "selected",
+ id => $ref->{id} };
+ } else {
+ push @{ $form->{"${module}_links"}{$key} },
+ { accno => $ref->{accno},
+ description => $ref->{description},
+ selected => "",
+ id => $ref->{id} };
+ }
+ }
+ }
+ }