I have an inventory program that I would like to have the ability to go and change or alter the field data based on the item number as a key. I have the menu option set but at the end of the script process it just appends the changed data to the database rather than what I would like; which is to replace the current item number and fields that were changed in the menu.

Any advice would be appreciated.

The inventory change script is below.

#!/bin/bash
#===================================================
# Script Name: invadd
# By: jhaynes
# Date: 4-4-2006
# Purpose: Script loop to add inventory to the HC
# computing inventory list, while preventing
# duplicate item#.
# Command Line:invadd
#===================================================
trap "rm ~/tmp/* 2> /dev/null ; exit" 0 1 2 3
invfile=~/final/hc_inventory
looptest=y
while [ $looptest = "y" ]
do
clear
tput cup 25 4; ./appendinv;
tput cup 1 4; echo "HC Inventory Change"
tput cup 2 4; echo "================================"
tput cup 4 4; echo "Item Number: "
tput cup 5 4; echo "Description: "
tput cup 6 4; echo "Dept : "
tput cup 7 4; echo "Cost : "
tput cup 8 4; echo "Qty : "
tput cup 10 4; echo "Add Another? (y)es or (q)uit: "
tput cup 11 4; echo "Please enter an item number or q to quit "
tput cup 4 16; read itemnum
if [ "$itemnum" = 'q' ]
then clear ; exit
fi
#Check to make sure the Item number field is not blank
if [ "$itemnum" = "" ]
then
tput cup 11 2; echo "***Item number can not be blank*** "
tput cup 13 2; echo "******Hit ENTER to continue******"
tput cup 4 16 ; echo " "
tput cup 4 16 ; read itemnum
continue
fi
tput cup 5 16; read descr
while [ "$descr" = '-' ]
do
tput cup 4 16 ; echo " "
tput cup 4 16 ; read itemnum
if [ "$itemnum" = 'q' ]
then
clear ; exit
fi
tput cup 5 16 ; read descr
done
tput cup 6 16; read dept
while [ "$dept" = '-' ]
do
tput cup 5 16 ; echo " "
tput cup 5 16 ; read descr
if [ "$descr" = 'q' ]
then
clear ; exit
fi
tput cup 6 16 ; read dept
done
tput cup 7 16 ; read cost
while [ "$cost" = '-' ]
do
tput cup 6 16 ; echo " "
tput cup 6 16 ; read dept
if [ "$dept" = 'q' ]
then
clear ; exit
fi
tput cup 7 16 ; read cost
done
tput cup 8 16 ; read qty
while [ "$qty" = '-' ]
do
tput cup 7 16 ; echo " "
tput cup 7 16 ; read cost
if [ "$cost" = 'q' ]
then
clear ; exit
fi
tput cup 8 16 ; read qty
done
#Check to make sure fields are not blank before you write the data4
if [ "$itemnum:$descr:$dept:$cost:$qty" > " " ]
then
echo "$itemnum:$descr:$dept:$cost:$qty" >> $invfile
fi
tput cup 10 33; read looptest
if [ "$looptest" = 'q' ]
then
clear ; exit
fi
done