Linking Fields in Same Table

[Moonman]

I have developed a form which the user is asked to select a customer's name from a drop down menu. I would like to have the customer's userid and phone # automatically inserted in two separate fields on the form when the customer's name is selected.

Thanx

 

[Pat Hartman]

This is best done with an autolookup query. You can find a description in help.