AnsweredAssumed Answered

How do I view a field in another table?

Question asked by JPetersen on Feb 10, 2016
Latest reply on Feb 10, 2016 by siplus

I have two related tables.

 

I have no trouble viewing related data from Table 1 in Table 2.

 

But sometimes ALL I want to see is a specific field (in this case the serial number) in the currently VISIBLE Table 1 record and view it in Table 2. The visible Table obviously might not be related to the current visible record in Table 2.

 

 

I have tried every kind of field type, calculation, lookup, and script I can think of, but it (of course) pulls the number from a related record, not from the currently VISIBLE record.

 

 

This should be dead simple and I can't figure it out.

Outcomes