Type phone number, pulls rest of info into form from client table

[jsbaby80]

I have a table that has client information and I have a form that keeps tracks of repairs. I want the client info to automatically fill in on the form when I type the phone number of that client (so I don't have to retype it for every repair that they have).
Please help...
Thanks!!!

 

[JeremyNYC]

You're definitely thinking along the right lines. Take a look at the "Fundamentals" article on my website, linked below. It explains why you'll want to have at least two tables, one for clients, and one for transactions (or repairs, or whatever you'll call them).

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.