It's not the column, but the fact that the database name is prepended. So the Select is
organizations.name but the join is to vcs.organizations.id Note the database 'vcs' pre-pended. >Typically there is a drop down list of fields in the join window. Witango >doesn't always select the right field for the foreign key. > >John >> >> I'm in the process of migrating from Tango 3.5/Butler to >> witango5-linux/mySQL. I'm a little curious about how the key fields are >> defined for joins in the search action. >> >> Here's a portion of the db to illustrate >> >> Database vcs >> >> Table users >> userid >> organizations_id >> >> Table organizations >> id >> name >> >> Previously, I would drag the foreign key "users.organizations_id" and the >> primary key "organizations.id" into the join tab, and the quoted columns >> would be inserted. >> >> Now, when I drag those columns, the join is made to >> "vcs.users.organizations_id" and "vcs.organizations.id" -- note the >> prepended database name. Curiously, the database name is NOT prepended >> to the column name in the Select tab. >> >> I'm using Openlink ODBC on the Mac Dev Studio. Is this a new "feature" >> to allow joins to disparate databases or is something else going on? The >> fact that I can't just convert my tafs without re-doing all the joins has >> me worried that the ODBC setup isn't right. >> >> Bill Conlon >> >> To the Point >> 345 California Avenue Suite 2 >> Palo Alto, CA 94306 >> >> office: 650.327.2175 >> fax: 650.329.8335 >> mobile: 650.906.9929 >> e-mail: mailto:[EMAIL PROTECTED] >> web: http://www.tothept.com >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf >________________________________________________________________________ >TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
