I have an invoice on my web page and a button that will save the invoice once all the required information have been added. And I created a data table that will save the details of the invoice. My table structure is as follows
|
Id
|
Uid
|
Email
|
Role
|
Name
|
CreatedBy
|
Date
|
Item
|
Qty
|
Rate
|
Amt
|
Total
|
|
1
|
1
|
a@mail.co
|
Admin
|
Ada
|
a@mail
|
09-Sep-20
|
food
|
8
|
100
|
800
|
2000
|
|
2
|
|
|
|
|
|
|
gas
|
1
|
500
|
500
|
|
|
3
|
|
|
|
|
|
|
serv
|
3
|
100
|
300
|
|
|
4
|
|
|
|
|
|
|
tables
|
4
|
100
|
400
|
|
|
5
|
|
|
|
|
|
|
|
|
|
|
|
From the table above, it is noticed that if I try to insert the data from the invoice into the data table some rows will be empty. For example, under Item column I have 4 items (food, gas, serv, and tables) and under Qty, Rate and Amt I also have some data which run into other Rows in the table, leaving some rows empty under Uid, Email, Role, Name, CreatedBy, Date and Total. If I want to display data from that data table in an invoice on another web form based on the user who created it, how is it possible, with the table description above?
