Lookup field values for multiple fields

supportt

Registered User.
Local time
Today, 14:02
Joined
Nov 21, 2001
Messages
70
I am working with one Form and have setup some of the fields as combo boxes that use the row Source Type and Row Source Properties. It allows the user to type the first part of a name and finds the rest in the drop down list. Is there a way to have one field, (say for example the Name) lookup other field values???? If the user finds Company Name ABC, once that value is selected, it does a lookup for the rest of the info, Address, City, State, Zip and Phone?

Thanks

David
 
Instead of basing your combo on a table or value list, base it on a query (click on '...'). Gather in the query all the fields you want to display from your various tables, then set up accordingly the number of columns and their widths using the combo properties. Beware to properly set the bound column property that represents the column you want to actually store values from (the others will just be displayed)
 
Lookup Fields

Alexandre- The click on option you talk about in your reply, is that the field property you are talking about? If so, should I just build it to to run the custom query, but I am a little confused about how the data is being passed back to the form? Can to expand a little on your last reply? I would really appreciate it.

Thanks for the help

David
 
At the right of the recordsource property of your combo, you will see these three points. Click on them and the QBE grid will be displayed, gather the fields you want as you would do for a query, then shut the grid. you combo is now based on a query and will display with each column corresponding to one field in your query.
 
Lookup Fields

I think we may be using a different version, I don't see the items you talked about. What I did was double click on the Name field and looked at the Row Source Type=Table/Query and Row Source=SELECT PRO_HSTA.CARRIER, PRO_HSTA.CARRIER, PRO_HSTA.CARRIER_ADDRESS, PRO_HSTA.CARRIER_CITY, PRO_HSTA.CARRIER_STATE, PRO_HSTA.CARRIER_ZIP, PRO_HSTA.CARRIER_PHONE FROM PRO_HSTA; . When I create a new record, it is not pulling in the other values. Is this what you are wanting me to do?

Thanks

David
 

Users who are viewing this thread

Back
Top Bottom