Sales Order Detail via ODBC

I'm trying to access XE's Sales Order Detail via ODBC and locating a record takes approximately one hour. Most of my other linked tables display the results within seconds.

When I link tables, I'm asked for the "Unique Record Identifier" and I assume I selected the wrong fields for this table. Can anyone tell me what the correct record identifier(s) is? Is there a listing of the correct record identifiers for all XE tables?

Thanks in advance,

BobAJones

Hello Bob,
In RDBMS language "Unique Recor Identifiers" are called Primary Keys; each table has one.
You should be able to get them at either DB (look into system tables) or Xe level, whichever you're most comfortable with.
Warm regards,

Adrian:
Thank you for your suggestion. You mention getting to the Primary Keys via XE. I've never heard of this, is this any information on this at the KnowledgeGarden?

Thanks,

Bob