Skip to main content
Question

Take related record ID and display text


I have a child table embedded in a form that allows our users to select quantity and type of an item. From there I am calculating costs of total "windows" for example. 

If they want (2) of window "1" and (3) of window "2" right now they fill out the table in the form and I have a summary field from my child table to my parent table that reports a Minimum record ID and a second minimum record ID in order to get both windows seperated in fields that I can work with on a word document for EFP with Field ID's. 

So far I am only getting the "related window" (1) showing up. I cant get all of the related window sizes to show up.   
Meaning on my form,  I am only seeing the number/ Record ID rather than the actual name of the Window its referencing. What am I overlooking. 
In the picture below I want "37" to read "3x2" or whatever window its referencing.  Or a field that I can do that.


------------------------------
Mike Klausing
------------------------------
This topic has been closed for replies.

I believe what you need to do is based off of those Min Rec ID#, build relationships to get the related fields.

------------------------------
Ryan Stanford
------------------------------