Claudine, The strange thing is, the grid is consistently not showing only one type of the inventory. The other types show up just fine.
Jim -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Tuesday, November 11, 2008 1:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: DB grid question Jim, Be careful that you don't have the same field names in related tables which contain unrelated data such as TimeStampDate or EditedBy. That's the easiest way to mess up a many-to-many relationship. Claudine ________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Tuesday, November 11, 2008 1:43 PM To: RBASE-L Mailing List Subject: [RBASE-L] - DB grid question 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
