Welcome to SPN

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

Sign Up Now!

auto update columns in a form

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

  1. General Training

    General Training
    Expand Collapse
    Guest

    In my main form, I want a subform that when I type an employees name, it
    automatically inserts the title and shift. Two tables involved, the Employee
    table has all the information. the Employees involved table should update
    with the entries in the subform. Please help
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Is Autocomplete Evil? Some Women Take A Hard Look at Google ! Breaking News Nov 7, 2013
    Sikh News AutoZone sued for firing Everett Sikh Breaking News Sep 29, 2010
    India Singh: Centre Ready To Give Kashmir Autonomy Breaking News Aug 11, 2010
    India Paste tariff cards behind driver’s seat: Transport dept to automen Breaking News Jul 21, 2010
    Gursharan Kaur: India's First Lady's Autobiography Sikh Personalities Jun 1, 2010

  3. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    You will need to set up a relationship between the tables - this could be the
    employeeID.

    Create a one-to-many relationship if employees can have more than one shift
    patten.

    If you're not to sure how to set the child/master critirea than a good idea
    would be to use the new form wizard. Click the main table (sinlge click so
    as not to open it)and click new object (it's at the top of the screen).

    Select form wizard and then follow the on screen tips and you will be able
    to create the form and sub form you're after.

    A good idea would also be to look at the new form in design view and then
    properties box to see how it is linked.

    Hope this helps





    "General Training" wrote:

    > In my main form, I want a subform that when I type an employees name, it
    > automatically inserts the title and shift. Two tables involved, the Employee
    > table has all the information. the Employees involved table should update
    > with the entries in the subform. Please help
     
  4. General Training

    General Training
    Expand Collapse
    Guest

    Thanks Wayne, do you know where I could find an example form that would do
    what I'm trying?

    "Wayne-in-Manchester" wrote:

    > You will need to set up a relationship between the tables - this could be the
    > employeeID.
    >
    > Create a one-to-many relationship if employees can have more than one shift
    > patten.
    >
    > If you're not to sure how to set the child/master critirea than a good idea
    > would be to use the new form wizard. Click the main table (sinlge click so
    > as not to open it)and click new object (it's at the top of the screen).
    >
    > Select form wizard and then follow the on screen tips and you will be able
    > to create the form and sub form you're after.
    >
    > A good idea would also be to look at the new form in design view and then
    > properties box to see how it is linked.
    >
    > Hope this helps
    >
    >
    >
    >
    >
    > "General Training" wrote:
    >
    > > In my main form, I want a subform that when I type an employees name, it
    > > automatically inserts the title and shift. Two tables involved, the Employee
    > > table has all the information. the Employees involved table should update
    > > with the entries in the subform. Please help
     

Share This Page