I need to know a little more about your table structure.
Can you send a screen shoot showing the structure of the Products and inventory tables.
it would also help to see a Product record and the related inventory record so I can get a better understanding of the relationship between the two.