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?