automatically update fields (1 Viewer)

[hermy]

i want it to automatically update a field from data entered into another field. similar to the v-lookup function in excel.
eg
enter the postcode and address will come up or enter mark and grade will come up!!

 

[Rob.Mills]

Do a search for Auto-Lookup Queries in the help section. It gives a good description of how to accomplish this.