ODBiC Discussion Board


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      20

and in the departments table: 12=engineering 20=accounts etc.

What I wanted to do on the QBE was to lookup the departments table and show the name 'engineering' or 'accounts'

Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.