Javier,
I knew there was something simple I was forgetting. That was it. Thanks for putting your 2 cents in. It works like a charm. 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
