lookedup column - view multiple values
Is it possible to view multiple fields within a lookedup column
For example:
MEMBERS database
ID
...other fields...
Member name
...other fields...
PAYMENTS database
ID
...other fields...
Payment
...other fields...
The PAYMENTS ID field is a lookedup field to the ID column in the MEMBERS database. When entering the payments ID, I would like to see the ID and Member name from the members database. Currently only the MEMBERS ID is displayed.
This would help me select the correct member.
Thank you.