Folks,
I have 2 Tables
Field Name (and data types):
Category ID (Autonumber)
Category (Text)
Sub-Category ID (Autonumber)
Cateogry ID (number)
Sub-Category (text)
Will be sufficient to display me sub-category commensurate to my clicking of Category? Help me please as I am not able to get it right.