Dropdowns (values from a database): Choice of category must correspond to subcategory
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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.