nbrown Posted March 27, 2002 Share Posted March 27, 2002 I'm working on a customer database related to a time billing database. And in the time billing database I have a drop down box that has everyone's customer number in there that a person can select to pull there info from the other database. Is there a way that when a person selects the drop down box it shows not only the customer number, but the company name? But then when one is selected it puts only the customer number in the field? Thanks, Nic Link to comment Share on other sites More sharing options...
Fitch Posted March 28, 2002 Share Posted March 28, 2002 Define your value list with the setting "Use values from a field." Then select the checkbox, "Also display values from..." Link to comment Share on other sites More sharing options...
nbrown Posted March 28, 2002 Author Share Posted March 28, 2002 Great! Thanks for the tip. Link to comment Share on other sites More sharing options...
redhotkoi Posted March 28, 2002 Share Posted March 28, 2002 i would like to see the second field when selecting but want both field to be displayed after it is selected. Thanks Andy Link to comment Share on other sites More sharing options...
Fitch Posted March 28, 2002 Share Posted March 28, 2002 Andy H, if you want to bring the second field over along with the first, then make the second field a lookup based on the first field. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8087 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now