AnsweredAssumed Answered

scale

Question asked by bennyruiz on Jul 15, 2017
Latest reply on Jul 16, 2017 by bennyruiz

i need help, Im confused i set up a table for a scale in a grain business, but the same scale is used for sale and purchases, there is also discounts for the grain humidity etc... the problem is that the amount  comes from the scale weight and need to multiply by price, since this net wight is used to adds and subtracts  is repeating records.

 

i would appreciate if someone tells me how to set up this data base

important tables are:

buy (id, invoice#, date)

sell (id, invoice#, date)

scale weight (id, invoice#, date)buyer

details (id,product,amonuntbuy,price, amountsell,pricesell)

seller (id, named address, phone)

buyer( id, named address, phone)

 

not sure if humidity and trash discounts should be in buy , sell or details

Outcomes