ODBC linked table showing only MAX date

[davea300]

Hi

Using access 2007 (and tried 2003) I have a linked ODBC table which is using an ORACLE driver. If I query the table directly through ORACLE/SQL for a particular 'job number' I get the following results:

18598979 3 06-DEC-13 10:10
18598979 0 03-DEC-13 10:34
18598979 1 03-DEC-13 10:34
18598979 2 06-DEC-13 08:20

However when I link the table through access and view the same job number within the table (not even using a query) it displays the following:

18598979 3 06/12/2013 10:10:00
18598979 3 06/12/2013 10:10:00
18598979 3 06/12/2013 10:10:00
18598979 3 06/12/2013 10:10:00

As you can see it only displays the MAX date/time and associated data from the 4 available records, duplicating the record. I've checked the field formats and they all look fine. It does the same if I pull through the table on it's own or with other linked tables. Any ideas?

 

[CJ_London]

When specifying the ODBC link to the table, did you ensure you specified a unique index?

 

[davea300]

You know when you stare at something for too long you miss the obvious. That's what I did, I just clicked cancel this time when access asked to identify the primary key in my link table and the queries are working now.

Slightly embarrased but thanks for your reply, you pointed out my mistake!