any working demo will be considered first.
I have three tables: USERS, INVENTORY(invprice), and CUSTOMER.
need to create INV_LINK table (this will hold prices if sold before to customer).
INV_LINK table will be same as INVENTORY, but will also include CUSTOMER_id
need to create INVOICE table to save invoice.
1) need to create an invoice by looking up INV_LINK table, and if not in INV_LINK table, look up in INVENTORY table
2) save to INVOICE table items sold.
3) save the inventory information, customer_id, to new INV_LINK table.
any other ideas to make it fast and easy be appreciated.
48 freelancer đang chào giá trung bình $161 cho công việc này
Hello! I am a web developer. I have checked your project description. I can do it I guarantee the good result. I will wait for your reply. Thank you.