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
