Merging Tables With Duplicat Primary Key's

[Guest]

I have several tables with very similar data. Each contains a field for 'game
name' and another 'system name' field (with a checkbox defaulted to 'yes' for
each entry). The 'game name' is the primary key for each table. I would like
to merge each table together into one large table or query (each table has
duplicate game name entries) that also has a 'game name' primary key, but
lists each 'system name' across columns and, of course, does not duplicate
game names. Is this possible to do, or did I go about creating these tables
in the wrong way?

 

[John W. Vinson]

I have several tables with very similar data. Each contains a field for 'game
name' and another 'system name' field (with a checkbox defaulted to 'yes' for
each entry). The 'game name' is the primary key for each table. I would like
to merge each table together into one large table or query (each table has
duplicate game name entries) that also has a 'game name' primary key, but
lists each 'system name' across columns and, of course, does not duplicate
game names. Is this possible to do, or did I go about creating these tables
in the wrong way?

I'd have used ONE big table, with a joint two-field primary key: SystemName
and GameName. You can run a series of Append queries to populate such a table.

To get rid of duplicate game names, you'll need some way to disambiguate them.
Are two records in two tables with the same game name in fact different
records? If so, you need (I presume) a new game name for one of them. Or if
you have the same game name in two tables, is it OK to simply discard one of
them?

John W. Vinson [MVP]