Claudine, that's great advice. This, to me, is one of those seeming innocuous, almost hidden, day-to-day and thus forgotten, things that are all so often the source of the most vexing "gotcha's". I sometimes use such (auditing/tracking) fields, too, and had never really considered this particular issue arising as a possible outcome of such use. So, I'm grateful to read your advice and lucky, I suppose, that I (don't think I) have encountered the problem yet.
Steve in Memphis -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Tuesday, November 11, 2008 1:55pm 13:55 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
