Hello,

Here is my case:

I have tables "Officer", "University", and "Country".  Officer is one-to-many to University, and University is one-to-many Country.  And, Country has a column "Region"

I am creating a view of the Officer table.  I would like each row to include the Region it's in.  (Essentially, I want to display the 'related field' of an already 'related field'...

So, when I write the form definition for the View1_Officer, I am having trouble referencing the Region column.  For example (this has syntax error):

list  View1_Officer

{

    show  all  rows  from  Officer

    (

        Name

        University_FK

        University_FK.Country

        University_FK.Country.Region   <---- wrong... how do i do this?

    )

How do I get that Region column into my view?