Thanks, Dawn, That helps a little.
In that case I would expect with a one-to-many property set, my third table would never show any data since it had no linking column to the first table! Instead, it pulled all the rows in the third table. Obviously, more light needs to be shed on this property! And, the many-to-many should be the default option, since it is the one most likely to be used. Dennis McGrath ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, May 30, 2008 12:49 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: conversion anomoly Ya - that's one of those things that's not instinctive, since it differs from the standard definition fo one to many and many to many. Basically, it's TABLES instead of RECORDS: With one to many, it means I can link one table to many tables. With "many to many", it means I can have many tables linking to many tables. I'm sure that's not the "definition", but that's how I learned to remember to check that box! Dawn Hast Dennis McGrath <[EMAIL PROTECTED]> wrote on 05/30/2008 01:09:52 PM: > Dawn, > > That was it! > > LOL! I check the help and it is not much help. > > What exactly does the "one to many" option do? The result > definitely does not look logical to me in any way. > The help does not tell me anything useful! > > Thanks > Dennis > > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Friday, May 30, 2008 11:44 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: conversion anomoly > > > Dennis, > > Make sure you have "Many to Many" checked under Form Properties > > Table Relations. > > Dawn Hast > > > > Dennis McGrath <[EMAIL PROTECTED]> wrote on 05/30/2008 12:40:20 PM: > > > I'm doing my first conversion from RBDOS 7.5 to RBWIN 7.6 > > > > I have a 3 table form with 3 regions > > > > RBWIN 6.5++ (latest version 1.866) converted the dos form fine. I > > tweaked the scrolling regions a bit and the form works great. > > > > I converted that form to 7.6 (latest version 3.30516) > > > > The third scrolling region does not link up correctly, it shows all > > the records in the third table, not just the records that link to table 2 > > > > Any way I can fix this short of removing the region and table and > > adding it back manually? > > I sure don't want to do this for all my 3+ forms!!! > > > > Finally trying to catch up! > > Dennis McGrath > > > >
