Hello everyone,
I have a Access database (2000) that has several tables that are links
to SQL Server 2000 databases.
One of these tables has the following fields (plus others):
Name
Agency
Each Agency can have multiple names. So one record might show:
Tom Smith 3A (3A being the agency code)
Then you could also have
Bob Jones (3A)
Is is the weird thing. When I open this linked SQL table in design
view, I see Tom Smith twice and Bob doesnt show up at all. However,
if I do a refresh, it appears fine. Also, if I import this table
directly into Access, this behavior does not happen.
Any ideas how to correct this? I need to be able to maintain the link
and see the correct data.
Thanks