I posted this on the table section but doesn't seem to get any respond..
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?
Basically, this database will enable management to see which group gets the most reports and what reports will require more stringent controls (based on the audience of the report).
also, if I have a field labeled Report Source, if the user has multiple report source, do i have to create multiple field (i.e. Report Source 1, Report Source 2, etc.) or can 1 field handle multiple entries?
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?
Thanks in advance.