Hi,
I'm new to Access, but I've used a lot of SQL
I dont really know where to start on how to do this...
I have items in a table that are organized by Category and SubCategory
where the SubCategories allowed should be dependant on the Category
how do I enforce such a dependance?
I've figured out how to make a column into a drop down selection lists, so you can choose a Category for a specified list
and figured out that the options for such lists can be populated via an SQL query
but I dont know how to attach information about another column of the current row being edited to this query
I want to do something like this
populate SubCategory list by:
select subcategory.id,subcategory.name from subcategory where subcategory.parentCID = ????currentrow.Category????
I've seen some tutorials that seem to do what I want, but all of them involve Forms input validation
I want this type of enforcement to exist within the Table itself
how do I do it?
thanks
I'm new to Access, but I've used a lot of SQL
I dont really know where to start on how to do this...
I have items in a table that are organized by Category and SubCategory
where the SubCategories allowed should be dependant on the Category
how do I enforce such a dependance?
I've figured out how to make a column into a drop down selection lists, so you can choose a Category for a specified list
and figured out that the options for such lists can be populated via an SQL query
but I dont know how to attach information about another column of the current row being edited to this query
I want to do something like this
populate SubCategory list by:
select subcategory.id,subcategory.name from subcategory where subcategory.parentCID = ????currentrow.Category????
I've seen some tutorials that seem to do what I want, but all of them involve Forms input validation
I want this type of enforcement to exist within the Table itself
how do I do it?
thanks