Make one Field dependent upon another

[David Ball]

Hi Forum,

If I have a Form that is used to populate a Table can I make one field entry dependent upon another?

For example, if I have a field for Discipline (with values such as Mechanical, Electrical, Piping) and another field for Equipment Type (with values such as Motor, Gearbox, etc) can I set up the Form so that when I select Electrical for the Discipline, only electrical items (such as Motor) are available to select for the Equipment Type field?

Using the table below as an example, if I select Electrical for the Discipline field in my Form, when I go to select a value for the Equipment Type field the drop down shows only Motor and Fan?

Discipline
Equipment Type
Electrical
Motor
Electrical
Fan
Mechanical
Gearbox
Mechanical
Pump
Piping
DN 150 Pipe



Or, better still, can I set it up so that if I select Motor for the Equipment Type field, the Discipline field will automatically be populated with Electrical?

Thanks very much

Dave

 

[David Ball]

Hi, it appears my example table has not come out as a table. Sorry

 

[pbaldy]

How about

http://www.baldyweb.com/CascadingCombo.htm

 

[David Ball]

Thanks pbaldy,

I will take a look at this and see if i can work it out

Dave

 

[pbaldy]

No problem; post back if you get stuck.