Database Structure

There will be 6 tables - tables for Redeem gift points needs to be made....

1. tbl_partner - This table will contain the necessary partner information like

partnerid
email
pwd
companyname
Address
City
State
Zipcode
ContactPerson1
ContactPerson2
Tel1
Tel2
FaxNo
IsActive
CreatedBy
CreatedOn
ModifiedBy
ModifiedOn

tbl_offer - This table will contain the scheme details

Offerid
Points
Product
Machines
IsActive
CreatedOn
CreatedBy
ModifiedOn
ModifiedBy

tbl_SerialMaster - This table will contain all the Serial numbers of a Product

serialId
SerialNo
MachineName
IsBlock
IsActive

tbl_claim - this table will contain the Claims of a Partner

claimId
ProductName
PartnerId
NoofMachines
T1InvoiceDate
T2InvoiceNo
ClaimDate
IsApproved

tbl_ClaimMachineSerial - This table will will stored the SerialNo;s Against a particulat Claim Registeration along with partner Id

ID
ClaimId
PartnerId
MachineSerial

tbl_Points _ this Table will contain the Points of a particulat Partner

PointId
PartnerId
PointsEarned
PointsRedeemed

Javascript on Dynamic Textboxes

A=0
B=0
if(this.document.f1.h1.value!="")
{

for(var A=1;A<=this.document.f1.h1.value;A++)
{
if(this.document.getElementById("txt"+A).value=="")
{
alert("Please enter no "+A)
document.getElementById("txt"+A).select();
return false
}
for(var B=A+1;B<=this.document.f1.h1.value;B++)
{
if(this.document.getElementById("txt"+A).value==this.document.getElementById("txt"+B).value)
{
alert("Two no's can't b same "+B)
document.getElementById("txt"+B).select();
return false
}
}
}

}