AnsweredAssumed Answered

Adding a sales table to my inventory database

Question asked by PeterMontague on May 31, 2012
Latest reply on Jun 11, 2012 by PeterMontague


Adding a sales table to my inventory database


I tried to set up a sales table on my inventory database. I set up a many to many relationship between my inventory table and my sales table by setting an in between table called line items. This allowed me to have a fairly functional relationship between my inventory and sales. I wanted each sale to reduce the stock levels in the inventory depending on the amount sold. 

I seemed to have a lot of glitchy problems. When I set up a portal where the items bought in an order were recorded the item did not go on the first line. I was also not able to record sales on the sales layout. I could only set up new sales on the inventory layout.

Any suggestions as to what I did worong?