access2007 can the yes/no be used to open up more columns/table/fo

total new to all things computers, and very slowly creating a database for my
own record keeping of work based files, i have a number of entries which
would only be required if i answered yes to in one field, but if i did answer
yes it would be worth openning as a totally new form as the number of entries
would be greater than 10 (each a selection from a dropdown box of atleast 6
options)
any help gratefully recieved but please keep it simple, or step by step when
i say new to computers i mean new taken me weeks to get this far and
countless sleepless nights with my head in manuals.

On Tue, 29 Sep 2009 18:35:01 -0700, boggle-eyed
wrote:

total new to all things computers, and very slowly creating a database for my
own record keeping of work based files, i have a number of entries which
would only be required if i answered yes to in one field, but if i did answer
yes it would be worth openning as a totally new form as the number of entries
would be greater than 10 (each a selection from a dropdown box of atleast 6
options)
any help gratefully recieved but please keep it simple, or step by step when
i say new to computers i mean new taken me weeks to get this far and
countless sleepless nights with my head in manuals.

Please describe the structure and relationships of your tables. It's all but
impossible to give a good answer. I worry that you're "committing spreadsheet"
(using multiple fields for the "same" kind of data).
--

John W. Vinson [MVP]

thanks John,
The only way i can begin to explain the tables and forms i have is to
explain the reason i have or am trying to develop them, sorry this is going
to be long winded but one to one, and one to many relationship is a little
beond my knowledge base at present.
I am a paramedic, and as such, for my licensening body, have to produce a
list of activities that shows that i have continued to learn within my role,
and prove i have used a wide range of media to do this. This table I have
called the ACTIVITY log, being employed by the NHS i am also required to
produce a KNOWLEDGE AND SKILLS FRAMEWORK (KFS) document this is to show what
current skill and practices i apply in my day to day work, covering thing
like communication, health and safty, for this i have the KFS table the link
and relationship for these two table was straight forward. and i can run a
number of querrys to find totalls of various examples of the elements i need
to evidence.
Both the two bodys require a list of all the jobs or incidents i attend, the
medical interventions i perform, and the various assessment, reports,
documentations etc. I deploy on that incident. this table, the INCIDENT log i
have related to a RESOURSE table, so i am not repeating vehicle call signs,
partner i work with, stations i deploy from, and a HOUR table so not to
repeat shift times and dates.
hope the above is not too confusing?
the question i raised to the yes/no function relates to the fact that some
incidents i attend and so entered in the INCIDENT LOG, are themselves
learning experience and so if i tick yes to a KFS column in this form/table
it could open a seperate form for me to enter all the relievant KFS aspects
that wouldnt be required in other incidents, the same applies to ACTIVITY log
unless the actual job shows deleopment i would not require the data, but if
one job contains elements of all three tables i am at present repeatedly
entering the same data in the three tables?
said it was long winded hope this explaination helps you help me


"John W. Vinson" wrote:

On Tue, 29 Sep 2009 18:35:01 -0700, boggle-eyed
wrote:

total new to all things computers, and very slowly creating a database for my
own record keeping of work based files, i have a number of entries which
would only be required if i answered yes to in one field, but if i did answer
yes it would be worth openning as a totally new form as the number of entries
would be greater than 10 (each a selection from a dropdown box of atleast 6
options)
any help gratefully recieved but please keep it simple, or step by step when
i say new to computers i mean new taken me weeks to get this far and
countless sleepless nights with my head in manuals.

Please describe the structure and relationships of your tables. It's all but
impossible to give a good answer. I worry that you're "committing spreadsheet"
(using multiple fields for the "same" kind of data).
--

John W. Vinson [MVP]