Following is a example of membership management system with automatic membership level upgrading feature, it will it automatically upgrade the specified member's level after they spent a specified amount of money.

*Click here to download the project file of this sample.(you can import the project file in Project Manager of ID Card Workshop)

Database Structure:

Field Name	Data Type
ID	Number
First_Name	Text
Last_Name	Text
Phone	Text
Email	Text
State	Text
City	Text
Address	Text
Postal_Code	Text
Date_Of_Birth	DateTime
Card_Start_Date	DateTime
Card_Expiration_Date	DateTime
Is_Card_Active	Yes/No
Photo	Image
Member_Level	Text
Total_Spending	Number

  Here is script that used for automatic membership level upgrading, the script will detect the amount of "Total_Spending" and adjust the Member_Level status.

if(Total_Spending>=0)
{
    Member_Level="Basic";
}
if(Total_Spending>=500)
{
    Member_Level="Bronze";
}
if(Total_Spending>=2000)
{
    Member_Level="Silver";
}
if(Total_Spending>=5000)
{
    Member_Level="Gold";
}
if(Total_Spending>=100000)
{
    Member_Level="Platinum";
}
if(Total_Spending>=200000)
{
    Member_Level="Diamond";
}