Pulling additional data into an admin page

Hi,

So if I understand you have a pull down field that pulls information from the MEMBER table. It's value is the num field and the label is the name field. You're already displaying the name when you're viewing your list of records, and you want to be able to view the number as well. Is that right?

If so, what you need to do is to make the num and the name part of your label. Edit your member field in your transaction table. For "List Options" select "Get Options From Mysql Query". Use this query:
SELECT num, CONCAT(num," - ",name)
FROM `<?php echo $TABLE_PREFIX ?>member`

This will display the record number and their name separated by a "-" like this:
5 - MemberName

Hope this helps.