I'm developing a Customer online ordering system using asp.net.
I created two tables Users & Orders.
1. User table consists of the columns (UserId, Username, Password etc.)
2. Order Table COnsists of the columns (OrderId, Order name,UserId)
I link two tables the User Table and order Table by specifying UserId in the User table as Primary key and foreign key as UserId in Order table.
Once a normal User looged in to the system, he should be able to create his orders.
Once he create order, his logged in Username should be stored in the Order table for reporting purpose.
How can i make this?
Please guide me on this.