linked table displaying different data than source

[wil]

I have a linked table in Access 2003 DB whose source is a View in SQL Server 2005.

The view is a Left Outer Join and the linked table displays what is essentially a different set of data than the source view.
--I should clarify here: in the data source, there will be 3 records for item #123 - each referring to a different supplier (Supplier # ABC, DEF, GHI)
--in the linked table there are still 3 records for item #123, but all three are for Supplier # ABC

I s'pose my question is whether anyone else has tried using a SQL View as source data for a linked table and run into similar issues?

[wil]

It appears that the two DBs are indexing on different fields.

Considering building the join on Access instead of using a View from SQL. Another option is building an actual table on SQL rather than using the view.