Skip to main content

Form Field Events Application

Last updated 25/07/2025

Database Structure​

An Orders application with four tables will be used to demonstrate the form field events. The database contains the following relationships:

  • The Orders table has a one-to-many relationship with the OrderItem table
  • The Product table has a one-to-many relationship with the OrderItem table
  • The Customer table has a one-to-many relationship with the Orders table
Orders database model
Figure 1- Orders database model

Core Requirements​

Products can be added into the system and stock quantity can be monitored.
Add products
Figure 2 - Add products

Customers can be added into the system.
Add customers
Figure 3 - Add customers

Customers can place orders.
Add orders
Figure 4 - Add orders

Customers can monitor the status of their order, for example, ordered, shipped, delivered.
Monitor order status
Figure 5 - Monitor order status