var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Populating table when choosing an option
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.
As a follow-up..
tblReportData has the following fields:
tblDistribution has the following fields:
d_distributioname is 1 to many to t_reportDistribution
d_distributionname values has:
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?