I have a situation where I would like to "mine" the database as I enter information to see if I have previously made contact. I would like this fuction to be a "on the fly" type of function where as I enter the information it "looks" for other contacts and pulls up that information for me.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Previous Contact
- Thread starter ziggyz
- Start date
forwardslash
IS-IT--Management
Which program and version are you using?
Michele P
Michele P
Hi,
It sounds as if you are wanting to use the "Autolookup" feature. For example, if you are entering information into a primary field of a form such as a "name", "social security #", "memberID", etc. -- if data already exists in association with this field it will automatically fill in the subsequent fields (i.e., "address", "city", "state", phone)with the pre-entered data.
If this is the type of action you are trying to create, then "Autolookup" is the feature/tool you want to use.
I hope this helps, if I can be of further assistance, please respond.
Angelica
It sounds as if you are wanting to use the "Autolookup" feature. For example, if you are entering information into a primary field of a form such as a "name", "social security #", "memberID", etc. -- if data already exists in association with this field it will automatically fill in the subsequent fields (i.e., "address", "city", "state", phone)with the pre-entered data.
If this is the type of action you are trying to create, then "Autolookup" is the feature/tool you want to use.
I hope this helps, if I can be of further assistance, please respond.
Angelica
- Status
Similar threads
- Locked
- Question