[vet-it] Autolook up again :(

[Keith Richardson]

Emma - I assume that you are referring to Access?
Forgive my saying this, but once you find it, it is so easy. Maybe you
are looking for something hard, but it is not so. In fact Access will
guide you to the auto-lookup through its wizards.
For example, if you are building a table with postcodes in it, in the
Design View (select the blue triangle to get to this view), in the Data
Type column rest the mouse on the postcode line & click the down arrow
then go to the botton choice "Lookup Wizard...". Just follow the prompts
from there.
OK? Please email me if you are still stuck. There are a few tricks, but
no point explaining them until you are working through the wizard...
Ciao for now.
Keith


On Wed, 08 Mar 2006 12:04:05 +1100, "Emma COUGHLAN"
<ec at sthelena.vic.edu.au> said:
> Morning everyone,
>  
> Call me an idiot - I still can not work out how to create an autolook
> up table. I am so annoyed right now - I have brought numerous books - 3
> in fact hoping that ONE could teach me how to do this access autolookup.
> Apparently none of the books can.
>  
> I am at my wits end - I have to run a sac (next term) for creating user
> and technical documentation and developing macros and templates and I
> need to know how to do this autolookup thingie. I have no other teacher
> in the school who is teaching this subject and its a new subject in the
> school.
>  
> what I need is basic instructions on how to create an autolookup table.
> I understand that I have asked for this previously - and I have tried to
> create one myself. Could someone please help me!
>  
> Kind Regards,
>  
> Emma Coughlan
>  
> Emma Coughlan
> Information Technology/Sose
> St Helena Secondary College
> Eltham North 
>  
> Phone Number: (03) 9438 - 8512
> Fax Number:      (03) 9438 - 8555
Keith Richardson
Leibler Yavneh College
Elsternwick Ph (03)9528 4911
keithcr at fastmail.fm