A
alex
Hello experts,
I have a question regarding linking a table in Access.
I go to FILE; GET EXTERNAL DATA; LINK TABLES. I then choose ODBC
Databases and link my chosen table.
During the process I'm asked to Select a Unique Record Identifier
(you can select up to 10).
When I select only one unique identifier, my data appears to duplicate
on particular rows and other data isn't select at all-the more
unique identifiers that I choose, the more accurate my data becomes.
The problem, however, is that I have more than 10 fields in my table.
Can I only link tables with <= 10 fields or am I doing something wrong?
Thanks for any help.
Alex
I have a question regarding linking a table in Access.
I go to FILE; GET EXTERNAL DATA; LINK TABLES. I then choose ODBC
Databases and link my chosen table.
During the process I'm asked to Select a Unique Record Identifier
(you can select up to 10).
When I select only one unique identifier, my data appears to duplicate
on particular rows and other data isn't select at all-the more
unique identifiers that I choose, the more accurate my data becomes.
The problem, however, is that I have more than 10 fields in my table.
Can I only link tables with <= 10 fields or am I doing something wrong?
Thanks for any help.
Alex