Query design to retrieve required input

[KevW]

I have been asked to create a database in Access 2000 that will hold 1.6 million postcodes. There will be four fields within the a table one holding the postcodes, and three fields holding information as to whether or not the post code is classed as good, neutral or bad. The requirements are to allow a user to run a query that asks thenm for the required postcode and then displays the relevant information (good,bad,neutral).

There requirement is that the search is done as fast as possible returning the required results. Has anybody got any ideas as to the best way of doing this.

 

[KeithG]

I would create two tables, each with two fields

tblPostCode
PostCode
ClassedID


tblClassed
ClassID
ClassValue

 

[KevW]

Further Question

Thanks for your quick reply I have added to your reputaion as this was not something I had thought of. I obviously could not see the wood for the trees. Just to get this right though the Classed ID in the tblPostcode relates to the ClassID in the tblClassed.

If this is the case then all I have to do is design the form that has the the query as the control source and the solution is there and hopefully it will suit the business requirement.

Thanks