I have a DB grid set up that takes a customer order (which has a product) then drills down to the parts making up the model and ends up with the inventory locations for each part. I have it working partially. I am getting null rows in my inventory locations when I show an inventory amount my Inventory table. These tables are a many to many relationship because the INVTABLE has just totals for each TYPE of inventory and the LOCATIONS table shows the many locations for that TYPE of inventory. Is there a setting I am missing?
I have all the tables in the Add/Remove section of the form. Jim
