Cascading Table

[TheRooseIsLoose]

Hey all! Long time reader, first time poster. I've been ploughing at this for most of a day now and it's starting to frustrate.

I'm familiar with the idea of Cascading Combo boxes in how they apply to forms. My problem is that my customers are using the table directly to edit data. So, I need to make a cascading combo or list box that works in a table.

I've attached my DB - it has three tables:
ValidPriReason - A list of the first error reasons that I want to appear in the list box.
ValidSecReason - A list of all secondary error reasons and their relation to the primary reason.
TestTable - the 'interface' table. When the customer chooses a primary reason in the first column of this table, I want the selection of secondary reasons (second column) to only display the relevant ones, not all possible secondary reasons.

Thoughts, anyone?

Thank you!!

 

[Mihail]

Long time reader, first time poster

Second time but WELCOME to AWF !

My problem is that my customers are using the table directly to edit data. So, I need to make a cascading combo or list box that works in a table.

Except the sluggishness, is no reason for this.
Design a very simple interface, as compact as you can, and show it to your user.
After the initial opposition they will be happy to use a single screen instead to navigate from table to table.

And now, the answer to your question:
As far as I know, this is NOT possible at table level.

Good luck with yours users !