How can I Store list of Grocey Item That Customer Buy with customer other Info In Mysql

I Made an Desktop application for grocery shop management using java,but i am facing problem in bill section.when i create a bill i store my data into mysql database in BillTable ,the screen shot of bill form is given. i can store billno, billdate,customer id, customer name,address,amount in database tabe. but for every bill how can i store items that customer buy. should i create new table for every bill? should i use list storage in mysql?

enter image description here



Read more here: https://stackoverflow.com/questions/64399065/how-can-i-store-list-of-grocey-item-that-customer-buy-with-customer-other-info-i

Content Attribution

This content was originally published by shreyash singrupkar at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: