I have a MS Access 2000 database with 136 data tables in it. What I would like to do is execute a piece of VBA code which will list for me in another table, (for example: Field1: TABLE NAME Field2: FIELD NAME 1 Field2: FIELD NAME2 etc), starting left to right, how many fields would have to be combined in each table to represent a unique record.
For instance:
TYPE ID TEXT
1 1 "Cats"
1 2 "Dogs"
2 1 "Rabbits"
In this example a combination of the fields TYPE and ID give a unique record.
Any help most appreciated.
Dalien51
For instance:
TYPE ID TEXT
1 1 "Cats"
1 2 "Dogs"
2 1 "Rabbits"
In this example a combination of the fields TYPE and ID give a unique record.
Any help most appreciated.
Dalien51
