Conditional list of records

[Tskutnik]

All, Thanks advance for the help. I have a form with 2 columns that need to relate. Both columns read from the same underlying table.

Form Name: [Contact Skills]
Form Fields being used: [Applications]; [Process]

They both refer to the underlying table: [AppTable]

The related fields are:
[Contact Skills].[Applications] reads [AppTable].[ApplicationName]
[Contact Skills].[Process] reads [AppTable].[ProcessName]

In the underlying [AppTable] there are many [ApplicationName] values for each [ProcessName]
Like this:

ProcessName | ApplicationName
Walk | Slow
Walk | Medium
Walk | Fast
Talk | Loud
Talk | Soft

Here is what I want - not too hard, I'm just lame...

When the [Contact Skills].[Process] combo box selects a value (e.g. "Walk") I want the [Contact Skills].[Applications] combo box to list only the relevant data (e.g. Slow, Medium, Fast)

I know there is a way to filter the [AppTable].[ApplicationName] data based on the [AppTable].[ProcessName] selected, I just don't know how.

Thanks so much. I'm not a coder so the more specific you could be on the actual code for this the better.

 

[pbaldy]

Sounds like:

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