aggregate MIN function not working in calculation
I have a portal on table 1 showing related records from table 2
Table 2 has two fields field 1(Number field with numbers) and field 2(text field with names)
I have a field on table 1 that is a calculation. I would like the calculation to find the lowest number in Table2:Field1 but to display the corresponding name from Table2:field2
I tried everything i can think of. I have no trouble getting the lowest # using the MIN function.