In MS Access how do you show value in field while referring to index value ?

Answer by  a28 (212)

Open MS ACCESS File and open the table and find the index value for the attribute, and at the end column you can find the value of the field you are referring for

Answer by  GAUTHAM (29)

Defining a default value for an Access field simplifies data entry when a certain value is entered frequently. If most of your plants require watering every week,you could set the default value to "weekly. " Then you will only enter data in this field if the watering frequency is other than weekly.

Answer by  gigo (1706)

You can use the function DLookup() or DomWert(). These function work even if the value is from an indexed field.