Hello,
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:

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 in advance.

This post has been edited by Alan_G: May 18 2011, 08:57 AM

I might use multi-select list boxes or even combos.

Go to www.fontstuff.com for some good examples.

OR www.datapigtechnologies.com even has video tutorials on how to set those up.

Thanks Milton..

I will check those sites.

The database I'm creating is suppose to be simple but it's turning out to be rather difficult. I'm thinking of just having one table and use every options as field names (i.e. instead of distributed to field with selection of "Board", "Department", "Manager", "Company" - I will make seperate fieldnames (Report_Board, Report_Department, Report_Manager, Report_Company, Report_Other, Report_Other_Name).

In my opinion, this would be a bad idea. Although it may seem simpler to set up, in the long run, it's going to bite you back. You might want to read a blog post of mine: The Problem of Repeated Columns (and subsequent posts) to see why.

Hi Roger,

In your opinion, how would one handle this then? I realize that Distribution_List is what my column should be but I have no idea how to capture in the table the various groups that gets the report.

Also, if a user selects "Other" and I want the user to tell me what "Other" is, how can I capture this on a table?

Thanks again!