I am trying to create a database that will eventually be fairly involved, but being the newb that I am I barely know where to begin, so I thought I would start with the Easiest part and then once I learned what I was doing just a little, I would work my way to the parts that will be more complex. So here is the issue right now...

I have my database with 2 tables right now, we will call them table_A and table_B

In table_A I have 2 fields, Category and Category_ID:

In table_B I have 2 fields, subCategory and subCategory_ID

I am not sure how to make it so that when I display the records from table_A in a dropdown list, any one of those given records could possibly (by some flag or something??) display all the records from table_B so my menu should end up something like this:

entry_from_table_A

entry2_from_table_A

->entryX_from_table_B

->entryY_from_table_B

entry3_from_table_A

entry_4_from_tableA

->entryX_from_table_B

->entryY_from_table_B

maybe this isn't as simple as I thought, but I just don't understand what I am doing. I *think* that I am working within the normalization rules because the entries from table B are not unique in the context of table A.

ANy help or examples appreciated

sounds like you're trying to create conditional value lists. see this thread