Hell All ,
Just we saw the problems that select the look up table data from 2 look up table.
One is diagnosis and second is treatment. So we could select the table_diagnosic , diagnosis 1 would like to show second table treatment_name.
it's possible to join 2 table and select the field.
This wiki page outlines the process for creating a "tiered" lookup table selection, is that what you're looking to build in this interaction?
It looks like you might also be trying to query into the second lookup table based on data from the first to count the number of treatment table rows which match the diagnosis id? This page goes over an example of how to query a table for its resulting value.
Thanks and yes
I just try to also query into the second lookup table based on data from the first to count the number of treatment table rows.
The second page should be helpful in constructing that query. You'll essentially be generating a reference into the second table with a query filter (inside the "[ ]") which restricts the query to only the rows which match the diagnosis ID selected in the first question.