Maintenance Log

Discussion in 'Microsoft Access Forms' started by rconnell, Sep 13, 2005.

  1. rconnell

    rconnell Guest

    Folks,

    I want to create a table which has 4 columns.

    ID (Primary Key) Machine Name Machine subsection Room
    1 MPP1 St12 - PnP
    XP03
    2 MPP1 St22 - Reject
    station XP03
    3 MPP2 St03 - Vision
    system XP16
    4 MPP2 St07 - Splice
    detect XP16
    5 Converter System die station
    XP12
    6 Converter Lane Die station
    XP12
    7 Casting Line Anvil Die
    XP07



    I want to be able to have another table which will be populated using a form
    which will allow the user to select the machine name in one field on the
    form and depending on the selection it will change a list available in
    another field which will allow the user to enter a machine subsection. I
    want the second field to be limited to the options associated with that
    machine. There is approx 30 machines and each might have up to 20 sub parts
    which the user will be able to select as they wish.

    They will also be typing in to other fields which will have problems and
    work carried out on that machine. This will be used as a handove database
    from shift to shift and also for management to query as they wish.

    Any ideas or help or examples.

    Regards

    RC
     
    rconnell, Sep 13, 2005
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. JUAN

    LOG ON FORM AS STARTUP

    JUAN, Jul 11, 2003, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    440
  2. Lesli

    "Overflow" Error message writing to audit log

    Lesli, Aug 8, 2003, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    174
    Lesli
    Aug 8, 2003
  3. Guest

    Last entry for Maintenance Scheduler

    Guest, Jun 24, 2005, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    126
    Guest
    Jun 25, 2005
  4. Guest

    remote maintenance

    Guest, Oct 4, 2006, in forum: Microsoft Access Forms
    Replies:
    3
    Views:
    145
    ruralguy via AccessMonster.com
    Oct 4, 2006
  5. Bill

    Maintenance Question

    Bill, Jan 20, 2007, in forum: Microsoft Access Forms
    Replies:
    2
    Views:
    147
Loading...

Share This Page