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.