Limiting values based on ref column

[pjt_glossop]

Hi everyone,

I'm a newbee to Appsheets having years ago been an Oracle Forms dev (please don't hold that against me!) and I'm really struggling with something that I am sure is actually really simple....

I have the following data model:

Table : Course Header

Columns : Course Name(key, label) - text, Prequisites - text, Training Qualification - yes/no, Related Instructor Details - List (I didn't create this, Appsheet has)

Table : Instructor Header

Columns : Instructor Name(key, label)  - text, Instructor Email - email, Related Instructor Details - List (I didn't create this, Appsheet has)

Table : Instructor Detail

Columns : Instructor Name (label) - Ref, Qualification - Ref, Completion Date - date

The key thing about the Course Header table is that it will contain some rows that have "Training Qualification = Yes" and some where "Training Qualification = No".

I have an app to enter a new instructor (ie populate the Instructor Header and Detail tables) and want to limit the values that appear in the Qualification field to only show those where Training Qualification = Yes"

I have tried putting the following expression in the 'Valid if' for the Instructor DetailQualification "[Qualification].[Training Qualification]=TRUE".  As a result I still get every entry in the Qualification table and it's only if I select one where [Qualification].[Training Qualification]=FALSE the error "This entry is invalid" on the form.  This is rather clunky and not very helpful to the user!

I have also tried putting the following expression in the 'Valid if "for the Instructor DetailQualification  select(Course Header[Course Name], Course Header[Training Qualification] = TRUE, TRUE)" but then I get an error ""=" requires arguments to be of comparable types. First argument must be Yes/No; received List<Yes/No>"

I'm stumped - what am I doing wrong?

Many thanks for any help/pointers

[Aurelien]

Hi @pjt_glossop 

Can you try instead:

SELECT(Course Header[idColumnOfYourtable], 
  [Training Qualification] = TRUE
)

For reference:

SELECT() - AppSheet Help