Form/table Design

[kiranair]

Hello ,

As am new to access I have a problem I don't know whether its big or small .


I want to create a table with around 30 fields, some fields should contain combo box ,combo box values are dependent on previous field .


i.e if I choose some value in Field1 it should show options in field2 that are related to the value in field 1 and so on for different values and different fields

should I use form or is it possible directly in table design plz help me briefly how to start


Please Help!!

[Missinglinq]

Data should never be entered directly into Tables, but rather through Forms.

The concept is called "cascading comboboxes" although the exact same thing applies to Listboxes with the MultiSelect Property set to None, and the code is interchangeable. Here are a couple of links with examples:

Cascading List for Access Forms

Cascading Combo/List Boxes

If you Google the term "Cascading Comboboxes" along with "MS Access" you'll probably get a gazillion hits!

Linq ;0)>

[kiranair]

thank you I ll try

[kiranair]

Hi
I have created a two table Process and category where process contains process steps and category contains different category depending on process I want to create a combo box such that when I select process , categories related to process has to be drop down.
I have 2 tables ProcessT(PID,Process name) and categoryT(CID,Pid,category name) after using below process its showing blank in category field in combo box plz help!!