Identical records in a Table

[Guest]

I am currently linking my table to a text file that is dumped multiple times
a day from a extract file from a larger database. I can not have access to
the larger database, only this file. My problem is when the data is dumped,
the key record (a idenitfying number) is duplicated because there is one
field that changes in each record and attached to this number. What I need
is to be able to have that identifying number be somewhat of a lookup
number...maybe. It may be easier to show an example.

9999 Store 1 CA Chicago
9999 Store 1 RR Chicago
9999 Store 1 MA Chicago

All data is the same except for the third field.

HELP!!!!!

Thanks

 

[Larry Linson]

Perhaps you have chosen the wrong combination of fields for your key if it
is duplicated -- would it be duplicated if you included the field which
changes? If not, then perhaps the real key actually should include that
field.

Good relational practice does include a key, but Access does not -- you can
use a "flatfile" approach, if you wish, where not having a unique key would
not be a problem.

Larry Linson
Microsoft Access MVP