Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    4

    Unanswered: relatiobships between three tables

    Hi,

    I need some help to design forms that could update infomation in three tables, below are my tables

    1. billing
    billingid autonumber(pk)
    name
    address
    phone


    2. reporter
    reporterid autonumber
    rname
    raddress
    rphone
    bid number (fk)
    3. contractor
    contractorid autonumber
    cname
    caddress
    cphone
    bid number (fk)

    My goal is to create three different forms to enter these data but really don't know how to do it.

    Please help!!!

    Thanks
    byfr

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Re: relatiobships between three tables

    Originally posted by byfr7
    Hi,

    I need some help to design forms that could update infomation in three tables, below are my tables

    1. billing
    billingid autonumber(pk)
    name
    address
    phone


    2. reporter
    reporterid autonumber
    rname
    raddress
    rphone
    bid number (fk)
    3. contractor
    contractorid autonumber
    cname
    caddress
    cphone
    bid number (fk)

    My goal is to create three different forms to enter these data but really don't know how to do it.

    Please help!!!

    Thanks
    byfr
    Use the Access form wizard and use autoform.
    Gregg


    DAO, ADO, SQL, Automation and anything else I can pick up.

  3. #3
    Join Date
    Feb 2004
    Posts
    4

    Re: relatiobships between three tables

    Originally posted by basicmek
    Use the Access form wizard and use autoform.
    Thanks. However, how could I use the form wizard and auto form at the same time???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •