change ALL the input fields from the following EXAMPLE:
Code:
<input type=hidden NAME="Date" VALUE="$rec{'Date'}" MAXLENGTH="12">
<table width="1000" border="0" cellspacing="0" cellpadding="3" bgcolor="#E0E0D6">
<tr>
<td colspan=3 bgcolor="#8A148A"></td><td colspan=2 bgcolor="#8A148A"><font color="#ffffff">Master Data Base</font></td><td colspan=3 bgcolor="#8A148A"></td>
</tr>
<tr>
<td>|; print &build_select_field ("Promotion", "$rec{'Promotion'}"); print qq|</td>
to:
Code:
<input type=hidden NAME="Date-$rec{$db_key}" VALUE="$rec{'Date'}" MAXLENGTH="12">
<table width="1000" border="0" cellspacing="0" cellpadding="3" bgcolor="#E0E0D6">
<tr>
<td colspan=3 bgcolor="#8A148A"></td><td colspan=2 bgcolor="#8A148A"><font color="#ffffff">Master Data Base</font></td><td colspan=3 bgcolor="#8A148A"></td>
</tr>
<tr>
<td>|; print &build_select_field ("Promotion", "$rec{'Promotion'}","$rec{'Promotion'}-$rec{$db_key}"); print qq|</td>
note: -$rec{$db_key} must be part of each field name
i only showed Date and Promotion above, but you must change all of them. the build_select_field etc now has three components instead of two, so be sure you made the changes to each of the build routines (build_select_field, build_radio_field etc) as noted in the multi mod