Dependant Lookup Fields in a table

[mountnco]

Hi all,
I've been trying to make an access database for locating our documentation on the network. The main table conatins entries for each document and also has 2 fields for categories. But I want the first categories field to determine what categories are available in the second categories field. Bascially I want a Primary Category and a Sub Category of the Primary Category! I was hoping this would work in the actual table without using forms! Is it possible for for this to happen? Please feel free to have a look at the database located at ftp://mountnco.kicks-ass.net/Documetation.mdb
Any Help and suggestions is greatly appreciated! Thanks in advanced!

 

[Remou]

You may wish to read:

The Evils of Lookup Fields in Tables

http://www.mvps.org/access/lookupfields.htm