AnsweredAssumed Answered

join data field

Question asked by nonsequitur on Apr 27, 2017
Latest reply on Apr 27, 2017 by beverly

Hello,

 

This is either not possible or so simple I am just missing the subtlety.  I have three tables.  The following data is an oversimplification, but works for discussion.

 

Table 1: Part_Description

Part_Number

Part_Name

 

Table 2: Part_Properties

Property_Key

Property_Description

 

Table 3: Part_Desc_Prop

Part_Number

Property_Key

Comment

 

Relationships are established between Part_Description and Part_Desc_Prop on Part_Number and Part_Properties and Part_Desc_Prop on Property_Key.  Members of each table for discussion purposes would be

 

Part_Description

PID00001 Honey

PID00002 Molassas

 

Part_Properties

1 Color

2 Appearance

 

Part_Desc_Prop

PID00001  1  light brown

PID00001  2  sticky

PID00002  1  dark brown

PID00002  2  sap like

In my layout, for the Part Description (and it may be so simple as I am laying it out on the wrong view) I have the Part_Number, Part_Description but I would like to assign the various properties to specific fields i.e.

 

Part Number: [PID00001]    Part Description: [Honey]

Color: [light brown]               Appearance: [Sticky]

 

This works fine when using a portal.  But when I try to access the data in discrete fields, using "Display Data From" in the Inspector, I can only access the first record in the record set.  I've even tried to assign calculation fields with no success.

 

Part Number: [PID00001]    Part Description: [Honey]

Color: [light brown]               Appearance: [light brown]

 

I figure there has to be a way to show the data in fields and not just in the portal.  But because I need to be able to view and modify the data as appropriate a list won't work on the same layout a list won't work, at least as I understand it.  There is some subtlety I am missing about how to access subsequent records in the join table record set, am I trying to access the data from the wrong layout?  If I use a different layout I still have the issue of being able to only access the first returned record.

 

Any answers anyone may have on this issue would be much appreciated.

Outcomes