form for data entry

[Guest]

I need to display all records on a single form for each person. The record
source is the following:

Name Level Date1 Date2 Date3 Date4 Date5
Jack L1 1/5/2005 1/7/2005 1/9/2005 2/4/2005 2/9/2005
Jack L2 3/3/2005 3/7/2005 3/9/2005 4/1/2005 4/6/2005
Jack L3 5/2/2005 5/5/2005 5/8/2005 6/1/2005 6/6/2005
Mary L1 2/5/2005 2/7/2005 3/6/2005 3/8/2005 3/9/2005
Sam R1 4/4/2005 4/6/2005 4/8/2005 5/1/2005 5/2/2005
Sam R2 6/1/2005 6/4/2005 6/9/2005 7/3/2005 7/7/2005
Sam R3 8/2/2005 8/8/2005 8/9/2005 9/3/2005 9/4/2005

Input screen for Sam:

Level R1 R2 R3

Date1 4/4/05 6/1/05 8/2/05
Date2 4/6/05 6/4/05 8/8/05
Date3 4/8/05 6/9/05 8/9/03
Date4
Date5
Date6
RSVP

Any ideas on how to do this ??? Thanks.

 

[Lynn Trapp]

Nancy,
Using repeating fields like Date1, Date2, etc. is an inefficient and
ineffective way to use a relational database. You have already discovered
how difficult it is to create a data entry form for that kind of data
structure. There are tons of other problems you will encounter if you keep
your table like that. You need to have more than one table. Can you describe
the business process you are trying to model?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Lynn,
The table is used to keep track of dates of phone calls, appointments, etc.
Sam has been thru 3 different levels of probation. Each level has dates for
when he went on probation, date for when letter notifying him was sent, date
for when he responded to the letter, date for when he is scheduled to meet
about the probation, etc. Since he has progressed from level1 to level3, we
want to see "at a glance" where he is in the process. We will enter a new
record for each level he is at. The main objective is to track him at a
glance. Hope I'm not too confusing with this explanation! Thanks for you
attention

 

[Lynn Trapp]

Nancy,
Well, with a second table to store the date fields, you can create a
form/subform and see everything you need quickly. Each date in the dates
table can have a level field that identifies each of the levels the person
has progressed to at any given moment in time.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

Lynn,
And that is where I need suggestions! How do I create a single form that 1)
displays all of Sam's data;i.e. info for any/all levels of probation for Sam,
2) allows data entry for a new level, and 3) updates any/all levels