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
