I have an access database (CMS system) with 3 tables:
catID (pk, autonumber)
subCatID (pk, autonumber)
intCatoNo (foreign key to catID from tblCat)
bodyID (pk, autonumber)
intCatNo (foreign key to catID from tblCat)
intSubCat (foreign key to subCatID from tblSubCat)
strHead (text - headline)
I have created a system that lets users create news like this:
1: choose_cat.asp: Choose a category from a dropdown - and click on submit (form).
2: create_news.asp: A page where the chosen category is shown along with the matching subcategories
This works just fine!
My problem is:
How do I create an edit module?
My dream is to create an edit page where the choice of a category will change to the matching subcategories.
I could use just a clue because I'm at a loss here.
I have made an edit module - I can change the category but I don't know how to autoupdate the subcategories.
Is this totally weird?