List boxes that filter fields on two different tables.

[#1]

I have two tables with the same field in both. I would like to have one list box that filters both these fields. For example:

Table1:

Process

Risk

Control

Table2:

Process

Tester

Test Manager

I would like to have one list box with 'process' that filters both tables. Is this possible?

[saumyashah90]

are they two different tables with no join?

By Default Process will get associated with both the tables.You can check typing Ctrl+t

[vishsaggi · Accepted solution]

Two tables will join if they have atlease one Fieldname common. So when you load these two tables, you should have only one FieldNamed Process which you can use as Listbox.

[awhitfield]

Hi Jessica,

that's the default behaviour in QV. Have you got some sort of issue with it? They will be linked by process.

Andy

[#5]

Hi there Jessica,

Yes, here you go. Data used is imaginary for demonstration purposes.

Step 1 - load your tables and check table viewer

Step 2 - add a list box for Process and a table box to show rest of the fields/values

Step 3 - select a value in Process list box to filter both tables, see below.

I hope this helps you.

Warm regards,

Nish