Auto Fill them fields

[PJHAction]

Point me in the right direction!

I have a table of names of people and a table of restraunts. I want to pull up the person which is already assigned a city by a field, I need the city information filled in on my form (like Zip, Restraunt name, telenumber&quot to be filled in. Not sure if I explained this correctly.

Pete

 

[RickSpr]

I think what you want is AutoLookup, but your description is too vague to explain how to make it work. Take a look at the FAQ in my signature line.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[PJHAction]

Thanks for the direction, I used Autolookup in query, man you really need the thinking cap on for this one.

Pete