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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pretzal

    Multiple field population based on one selection

    Thank you! That is what I needed to know. I appreciate you help!
  2. pretzal

    Multiple field population based on one selection

    LittleSmudge, Yes, One company name = one company code. I need to display the company name for the ease of use to the user. I want to pull other information using only the company code. Therefore I feel in one of my tables I need the company name and the company code in the record. When the...
  3. pretzal

    Multiple field population based on one selection

    I appreciate all the help that you are tring to give. However, all you seem to be doing is picking apart my every response. I realize that a pk can not change without being updated in all places that it exists. The only thing that I really want to know was the original question and how to do...
  4. pretzal

    Multiple field population based on one selection

    NO NO I ment the if a company name changed the a company code would change also. I have a form so that the user can do all of that. I did not mean code as in access code.
  5. pretzal

    Multiple field population based on one selection

    I still do not know if you can pull multiple field from a record based off of one selction.
  6. pretzal

    Multiple field population based on one selection

    They are actually state agencies. If any changes occour then the respective code will also change.
  7. pretzal

    Multiple field population based on one selection

    no the company name is the primary key.
  8. pretzal

    Multiple field population based on one selection

    Lespaul, what other methods are there for making sure the user does not enter incorrect data? Should I be doing this with look ups on forms?
  9. pretzal

    Multiple field population based on one selection

    What I have is tbl1 (company info) Fields include company name, company code, and company abbreviation. Company name is the primary key. The second tbl (representative contacts) has representative name, company name (this is the forgien key from tbl 1, copany code, phone, email. In tbl 2 I...
  10. pretzal

    Multiple field population based on one selection

    I have two tables. One has a company name and the associated company code information in it. In the other table I provide a look up box for the company name. Also in this second table is a spot for the company code. How can I populate box the company name and code portions in this second...
  11. pretzal

    How do I make an Access query automatically open a report?

    I am trying to generate a report based off of a query. However, I am using a dropdown selction box to choose criteria for the query. Once the criteria is selected, the query automatically runs and the data view is displayed. I do not want the user to see this data view. I want a report to...

Part and Inventory Search

Back
Top