Jim,
As Doug had pointed out in an earlier email you probably need to look at changing your data structure to not have duplicate columns in your tables other than one linking column. Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, January 26, 2010 2:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Enhanced tab I found another reason my information was not showing up. One field does not always need information so it ends up being NULL. Even though both fields in both tables are null, the form refuses to show the detail row. My settings have ZERO checked. Other than getting rid of that common field in the detail section (which I may have to do anyways) what can I change? Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Tuesday, January 26, 2010 2:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Enhanced tab Also, under form properties, make sure that under the "table relations" tab Many to Many is selected. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax _____ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, January 26, 2010 2:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Enhanced tab Thanks for the information. I will check to make sure the common columns have the same exact information. _____ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Tuesday, January 26, 2010 2:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Enhanced tab << I just did not know if an Enhanced tab form had a specific way to connect the two tables. >> There is nothing special about the Enhanced Tab form in terms of linking information. Fields for different tables on different tabs will follow the general R:Base rules of linkage, which state that a "Natural Join" is used to determine which rows, if any, from the second table are shown. A natural join is one in which all columns with the same name must have the same value in each of the two tables. -- Larry
