List box problem

[hugz via AccessMonster.com]

I got my Row Source on my "DVlistbox": transac#, DV#, Date, Payee,SupplierID,
and ExpenseID.. all of these fields are taken from my tblTransaction.. But
both the SupplierID and ExpenseID shows on the list as ID or numbers.. I want
the list to show the exact description of the ID and not the number.. I tried
including both my tblSupplier and tblExpense in my and placed both the
Supplier and expense description of the ID on the Row source.. but nothing
comes out of the list..

any solution to this..?

pls help me..

tnx..

 

[Klatuu]

If the SupplierID and ExpenseID are lookup fields, that is the problem.
Lookup fields are more trouble than benefit. The best I ever heard them
describes was "misfeature"