I need a kick start

[deb]

I am trying to build a db in access 2003

it has riskSections... Schedule, Technical, Commercial, Financial, and so on
each section has Topics... Warranty, Change Order, Scope, Sourcing, and so on
each topic has Issues...Non standard warranty, Contact on Customer terms,
and so on

I need to have the issues listed with a check box or other option.
If the issue is applicable they check the box and the issue with a rating
number should be added to a table for calculations.

Since I need a multiselect written to the table, I am not sure how to set up
the tables.

HELP

 

[Jeff Boyce]

Deb

You are describing a "how", as in how you've decided you need to structure
your data.

We aren't there, and may not have any familiarity with the arena in which
you are working.

If you'll provide a bit more context about your situation, and your proposed
table structure, the folks who frequent the newsgroups will be better able
to offer specific suggestions.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[deb]

to make it simple...

my form is silular to a questionair where there are multiple questions. the
checkbox is checked if the question applies to the project. The ranking of
all questions are summed for a project ranking total.

how is the best way to setup a table to store the question and answers and
rankings.

Is the checkbox the best way or is there alternatives?
IF a chck box is checked and it is written to the table. and then it is
unchecked, will it delete the record? Should I have a field for each answer
or one field for all answers?

 

[John W. Vinson]

I am trying to build a db in access 2003

it has riskSections... Schedule, Technical, Commercial, Financial, and so on
each section has Topics... Warranty, Change Order, Scope, Sourcing, and so on
each topic has Issues...Non standard warranty, Contact on Customer terms,
and so on

I need to have the issues listed with a check box or other option.
If the issue is applicable they check the box and the issue with a rating
number should be added to a table for calculations.

Since I need a multiselect written to the table, I am not sure how to set up
the tables.

HELP

You're making a lot of assumptions about our knowledge of your business terms
and practices. I have no trace of an idea what a riskSection might be.

All I can really suggest is that multiselect listboxes may be an awkward tool.
If you have a one to many relationship, you need *two tables* or perhaps
three. If one (whatever it is, you don't say) entity has many risk sections,
and each risk section can apply to many (whatevers), you need three tables:
Yourmaintable, RiskSections (with the values you list and more), and a third
table linked to both of them. You'ld use a Subform to enter data into this
third table.

Check out some of the ideas about how to get started with normalization at:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials



John W. Vinson [MVP]

 

[Steve]

FYI in case you are interested ---

A service I provide is to design the table structure of a database for a
customer. I have done this for numerous customers. My fee is very
reasonable. I provide a map of the tables that shows all the tables in the
database, all the fields in each table, all the relationships between the
tables and the type of relationship for each relationship. The tables are
arranged on the map generally as the flow of information in the database. I
create a map of the tables for every database I do. The map visually shows
what forms and subforms are needed for data entry, shows what special forms
and subforms can be created for dispaying data in the database and shows
what reports and subreports can be created from the data in the database.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Jeff Boyce]

I asked about your data... you told me about your form.

Access is a database. It all starts with the data. If you throw data into
a database from, say, a spreadsheet, you are very unlikely to be able to use
the features and functions that the database has, as it is expecting data
organized a different way.

If you want help with your forms, that starts with your data.

(... and you DID post in the tablesdbdesign newsgroup, right?<g>)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Jeff Boyce]

Please...

....these newsgroups are here for folks to get free assistance.

Post your advertisements in a more appropriate venue.


--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John Marshall, MVP]

You are really on a roll tonight. By the way, we are NOT interested.

These newsgroups are for FREE peer to peer support, not a place for you to
prey on unsuspecting victims.

John... Visio MVP

 

[Tony Toews [MVP]]

A service I provide is to design the table structure of a database for a
customer. I have done this for numerous customers. My fee is very
reasonable.

More soliciting for business, eh? Please go away.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

A service I provide is to design the table structure of a database for a
customer. I have done this for numerous customers. My fee is very
reasonable. I provide a map of the tables that shows all the tables in the
database, all the fields in each table, all the relationships between the
tables and the type of relationship for each relationship. The tables are
arranged on the map generally as the flow of information in the database. I
create a map of the tables for every database I do. The map visually shows
what forms and subforms are needed for data entry, shows what special forms
and subforms can be created for dispaying data in the database and shows
what reports and subreports can be created from the data in the database.

I think I've seen that exact same wording in other posting of yours
recently Steve. If you are using my NewsgroupAnswers.MDB please stop
using it. Create your own.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Arno R]

I think I've seen that exact same wording in other posting of yours
recently Steve. If you are using my NewsgroupAnswers.MDB please stop
using it. Create your own.

Tony

He 'could' be using your NewsgroupAnswers.mdb
He 'would' even try to sell this db to his numerous customers... !!

But my guess is that he uses something like 'signatures' in OE.

Arno R

 

[Keith Wilby]

FYI in case you are interested ---

A service I provide is to

.... hack people off in a big way. It's time to "see the light" brother.