Hello,
We have a Access 2003 front-end and back-end file for an application.
We are moved the backend to SQL Server 2008 R2 using the SQL Server import/export wizard. That all seemed to work out fine.
My question is with the relationship tool inside Access. When I add the new SQL tables to the relationship window and do a join, it looks different then the Access table relations. Please see the screenshot for clarification.
Some of my questions:
1. Why doesn't the relationship for the SQL tables show a One-to-Many symbol?
2. Why does the "Relationship Type" for the SQL tables say "One-To-Many", while the Access tables say "One-To-Many (External)"?
Attachment 11496