QBE lookup field
by Jon Grosse, June 26, 2007 05:52
I have a QBE screen where one of the fields is a number, this number refers to a sub-table where the more meaningful description is held.i.e on the QBE: assetid department 12345 12 67890 20What I wanted to do on the QBE was to lookup the departments table and show the name 'engineering' or 'accounts'
and in the departments table: 12=engineering 20=accounts etc.
Name E-mail optional TopicMessage:
HTTP Link: Link text: