adding information based on "if yes" response

[JessJohnson]

I am probably the most inexperienced Access user you will ever encounter. I
was elected to created a database on an emergency basis. My database is to
handle information for a class action lawsuit. In some tables I have fields
that require a "yes/no" response. If the answer is yes, I will need an
explaination, how do I set up this field.

Also, one record in one of my tables is for work history, some may have had
one job, others many, how do I provide for this varying number on the table?

I really hope these questions made sense. I am desperate for an answer. Even
better, If anyone knows of a service that I can use that will set up the
database for me relatively quick ( I have detailed list of information to be
included on table), please let me know, I think I would be willing to pay for
this service out-of-pocket if I had to.
Thanks,
Jessica

 

[Alex White MCDBA MCSE]

Well it sounds to me that you need details of the people that you want to
join the class action

I would suggest a Contact table for this
e.g.

Field name field type

Contact_ID autonumber
Title string
First_Name string
Surname string
Telephone string

etc.....

A Class_Action Table (so you can use this database for other class actions

Field name field type

Class_ID autonumber
Class_Description string


A Class_Members Table (entries for each member joining class action)

Field name field type

Class_Members_ID autonumber
Class_ID numeric
Contact_ID numeric
Joining_Action yes/no
Joining_Notes memo


The simple idea here is this, create a record in the Class_Action table for
the specific class action, add all the contacts you have in the contacts
table

then for each person that is joining the action you need a record in the
class_members table

the class_members table will need a valid class_id and contact_id then you
can add the other information you need,

you need a set of relationships going from the Contact table to
Class_members (1 to many) and Class_Action to Class_Members (1 to many)

post back if you need more info.