Rob, My guess is that you do not have a Primary Key defined in the table structure. The R:Tango builders use Primary Key information to build the links. If a table doesn't have a PK, R:Tango guesses. You can override incorrect guesses in the colum properties.
>From the "User Guide", "Using Data Sources" chapter: A primary key column is a column (or combination of columns) whose value uniquely identifies each row in a table. For example, a customer number might be the primary key in a customers table. Primary key columns are identified in the Data Sources Workspace by the column/key icon. Tango builders rely on the primary key column values in various places to identify specific records. When using the builders, it is important to first check that the primary key for each table involved is set correctly. If the specified column or columns do not uniquely identify each record in a table, unexpected results can occur when executing the file. For example, if you mistakenly set the primary key column for a customer table to the �state� column (many customers likely share the same state), using the resulting file to delete a particular customer deletes all the customers in the same state. When connecting to a data source, Tango Editor queries the database for information to determine the primary keys. If there is no response, Tango determines the default primary keys by scanning each table for the first column with an appropriate data type (numeric or character). Primary Key Using the Primary Column Key To change or add a primary key column Do one of the following: In the Data Sources Workspace, right-click the column and choose Primary Key from the context-sensitive menu that appears. A check mark in the menu identifies a primary key column. Right-click the column in the Data Sources Workspace, choose Properties from the context-sensitive menu that appears, and check or uncheck the Primary Key check box in the Properties dialog box. Select a column in the Data Sources Workspace and choose Primary Key from the Data Source menu. A check mark in the menu identifies a column as a primary key. Bill On Sun, 10 Nov 2002 10:01:58 -0500, Rob Vincent wrote: >I've been having a row retrieval problem using R:Tango. > >It seems that if the first column in the table does not contain unique data, >when a record is selected for viewing, the database is referencing the first row. > >However, if I change the first column to contain a unique number, the correct record >is displayed when selected. > >I have noticed that the record selection will fail even if I put the unique numbered >column in a different position (other than the first) in the table. > >Am I missing something here? Any guidance would be greatly appreciated! > >Thanks, >Rob Vincent >Dearborn Heights, Michigan > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
