0

how to project this db

Hello need to manage my small business. Every day X products goes out from my store to my clients, and Y products return (my client has not sold them all). So i think a table for products i sold, and a table for clients. Then my doubt is how to manage the sold product and the returned products Shall i do 2 different tables, one for sold one for returned? That means that i wil have a table with

date client product sold quantity

and the other with product returned insted of sold

At the end i must be able to see the overall product sold/retruned by clients and percentage

And also to see by products the relation sold/returned

For this i see the report/graphic available don't allow me to get data from 2 different tables..so how can i do that?

101 replies

null
    • Fred
    • 1 yr ago
    • Reported - view
    stef. idea said:
    how you resize the field?

     In admin mode, select the field and you see squares on the two short sides of the field. Drag the squares to change field size.

      • stef_idea
      • 1 yr ago
      • Reported - view

      Fred 👍

Content aside

  • 1 yr agoLast active
  • 101Replies
  • 445Views
  • 3 Following