Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Help!!!

Discussion in 'Information Technology' started by Candace, Jul 28, 2006.

Tags:
  1. Candace

    Candace
    Expand Collapse
    Guest

    I've set up a form in Access that pulls information from records in one table
    to be used in another. It asks for a job number, then pulls up that record.
    I need to be able to type in the empty fields located on this form. Does
    anyone know how to do this?
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 7 Jun 2006 13:04:01 -0700, Candace
    <Candace@discussions.microsoft.com> wrote:

    >I've set up a form in Access that pulls information from records in one table
    >to be used in another. It asks for a job number, then pulls up that record.
    >I need to be able to type in the empty fields located on this form. Does
    >anyone know how to do this?


    How are the two tables related? You should almost certainly NOT be
    copying fields from one table and storing the same data in another
    table; the whole point of a relational database is that you enter and
    store data ONCE, and then use queries to look it up.

    Please explain what you mean by "to be used in another". I suspect
    that a Subform will be appropriate, but don't know quite what your
    structure is!

    John W. Vinson[MVP]
     

Share This Page