View grandchild records in form

Question

I have 3 tables: Assessment, Locations and Workstations. Assessment connects to one or many Locations; A location has many workstations.

I would like to display the grandchild (workstation table) records in the Assessment form? Is this possible without making a relationship between assessment and workstation table?

I am afraid that making a triangle relationship may result in mismatched data (if workstations are moved from one location to another). Please advise. Thanks.

------------------------------
Uma Harithsa
------------------------------

LauraThacker · Accepted Answer

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
------------------------------

Sign up

Login to the community