<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Hi everyone,</DIV>
<DIV> </DIV>
<DIV>I need help with creating an auto look up query using access. As you need two tables my predecessor has not included a second table on the network for me to complete the auto look up queries.</DIV>
<DIV> </DIV>
<DIV>Therefore I have to create another table which is fine - I can do that. However I can not work out how to do the auto look up queries.</DIV>
<DIV> </DIV>
<DIV>I am at my wits end! I have the Barnes book currently in front of me (the green one), been to the online help, I have books everywhere to find out how to do this auto look up queries.</DIV>
<DIV> </DIV>
<DIV>Could anyone out there please PLEASE help me! - even if you send me two tables which I can use to do the auto look up queries - it would be most appreciated!</DIV>
<DIV> </DIV>
<DIV>Its on page 6-8 of the barnes book for anyone who has that book.</DIV>
<DIV> </DIV>
<DIV>Thanking you in anticipation :)</DIV>
<DIV> </DIV>
<DIV>Em Coughlan (Stressed out!)</DIV>
<DIV> </DIV>
<DIV>Emma Coughlan<BR>Information Technology/Sose Teacher<BR>St Helena Secondary College<BR>Eltham</DIV></BODY></HTML>