Force "Select Unique Record Indentifier" when linking tables

[RickBerem]

Hi,

Ok, quick description of my troubles. I'm trying to link a SYBASE table by ODBC. Access makes the link with no problems. Now, the trouble is that the original table as a 2 field primary key. When access links it, it takes only one of the field as a primary key.

What happens then is that I get the correct ammount of records but I only see the first of the set (Simply put, in a 10 lines order I get 10 lines but all of them are equal to the first line )

Now, I would like to know if it's possible when linking to force the prompt so I could set the primary key to the 2 fields and hopefully fix my problem.

Thanks for your thoughts

SG

 

[AlexCuse]

When linking tables, you can control-click on more than one field to set them as the primary key. Re link and try that.

Alex


It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.