Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    2

    Question Unanswered: Populating table when choosing an option

    Hello,

    I'm new here so please bear with me. I'm trying to put together an inventory database for all types of report. So far I've created 3 tables:

    tblReport (main datasets)
    tblDistro (houses the names of who gets the report)
    tblSystem (houses the systems that are use to run a particular report)

    In the fom, there is a question:
    Who gets the report? and I would like for the choices to be the following:

    Board (checkbox) Department (checkbox) President (checkbox) Other (checkbox)

    When setting up the table, do I need to create a list with these options? Also, how do I make it so that user can select multiple (Board and President and Other).

    Once the select Other, I would like for the user to enter the name. How will this populate the table?

    Sorry if it's a loaded questions.

    Thank you very much.

  2. #2
    Join Date
    May 2011
    Posts
    2

    Question Follow-up

    Hello,

    As a follow-up..

    tblReportData has the following fields:

    t_reportName
    t_reportOwner
    t_reportDistribution
    t_reportApprover
    t_reportPeriod

    tblDistribution has the following fields:

    d_distributionname

    d_distributioname is 1 to many to t_reportDistribution

    d_distributionname values has:
    Board
    Department Level
    President
    Other

    I would like to know..
    1. if the report goes to Board and President, how can the user select these two fields
    2. if the user selects Other, I would like for them to be able to type the name and how will this populate the table?

    Thanks again.

Posting Permissions

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