Hi Everyone,

I have a database that is working great. However, when I add a record it posts it to the .db file twice. I know the reason but don't know how to fix it. We have certain fields where only admin can see them. We set up the record routines like this.

If ($per_admin) {
print qq|
<table>
<tr><td>field1<td></tr>
<tr><td>field2<td></tr>
</table>|;}
else {
<table>
<tr><td>field2<td></tr>
</table>|;}

Of course, this is a much reduced version. When this record is posted to the .db file it has:
Value for field1|Value for field2|Value for field2

In other words, it merges the non-admin fields with the admin fields.

I also noticed that when a user does a search and wants to sort the output by a field that the field list has the duplicated fields. The fields are listed in the order of admin accessible fields and then non-admin accessible fields.

How do I fix this problem?

cwhatley