View grandchild records in form

The most common way of displaying data in a grandparent from a grandchild set of records is to use a Report Link field.  If you do not already have it, create a Lookup field in the Locations < Workstations relationship and select the field [Related Assessment] (related reference field connecting your Locations to the Assessments table.

Then in your Assessments table, built a new field [Workstations this Assessment] with the Type Report Link.  The field settings would be [Record ID#] on the left and then you will select the target field as the same-application; Workstations table and look for the [Related Assessment] field in the list.  Select that and you now have a field that will allow you to embed onto the Assessments table form layout a list of the Workstations associated to the Locations under that Assessment.

------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------