Looking up a looked up look up value!

[Sarella]

Hi,

I'm trying to make one look up table look up the value from another look up
table, and report the worded value rather than it's numerical representation.

Example:
Table A, Shifts = Days (1) / Nights (2)

Table B, Customer pricing for days and/or nights which looks up table A for
shift values (this works sucessfully)

Table C, Labourers working for customer which needs to look up available
shift patterns from table B, ( this reports back either (1) or (2) rather
than the word Day or Night


How do I get this to work and show me the words rather than the numbers?

Many thanks for any assistance as it's driving me mad now!

 

[Douglas J. Steele]

Using Lookup fields? I don't believe it's possible. While it may look as
though Table B contains Days or Nights, all that's actually stored in the
table is 1 or 2.

Fortiunately, this shouldn't be an issue, since you should never be working
directly with tables: you should always use a form when interacting with the
data. On your form, you'd bind a combo box based on TableA for the
appropriate field in TableC.