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.
JDRAW,
Is there any mistake in my table creation. This is my field name and data types
Table name: tbl_Ccategory
Field name: Category ID; Data type:Text
Field name: Category; Data type :Text
Private Sub cboCategory_AfterUpdate()
Me.CboCategory.Requery
Me.CboSub_Category.Requery
End Sub
Private Sub cboSub_Category_AfterUpdate()
Me.CboSub_Category.Requery
Me.CboCategory.Requery
End Sub
What will I get from this? I was trying to (in form) display subsets of a category. Its not happening.
Re: Table design
I am designing a database for my part time. I created tables:
Table name: tbl_Ccategory
Field name: Category ID; Data type:Text
Field name: Category; Data type :Text
and I want to use this table for cascading combo form along with another table-sub-Category.Do I have to make...
Hello all,
I am from Bhutan and am slightly new to MS Access. I want to make use of the powerful use of it and am looking for a step-by-step constructive help.