Basic Question about data entry from forms

  • Thread starter Thread starter Kevin Smith
  • Start date Start date
K

Kevin Smith

I will try and make the following problem as easy as possible to
understand.

I have two tables and two forms for entering information about work
experience students. 1st table contains personal details plus a start
and finish date. This info is entered via a form. The second table
contains fields for entry of two seperate dates and a team name. the
idea is that if a student is with us for 2 weeks he may spend 1 week
with one team and 1 week with another.

What I have working well is the first form, but I want to put a next
button on it that will allow me to open the second form and enter
information about where the student is to be working for the period of
time he is with us.

I have entered an autonumber primary key called ID in the first table
and entered the same on the second table as a number field and
assigned a one to many relationship, which I believe is correct.
However I am unable to figure out how to actually have the information
linked. So I can use the first form to enter the students details and
say that his stay with us is 2 weeks, then to open the second form and
enter information to say that he is with Team A for 3 days Team B for
1 week and Team C for 4 days etc. And have that information entered
into the second table as 3 records with the same ID as the students
details record.

If anyone here can debase themselves enough to help me I would be most
grateful.

Many Thanks

Kevin
 
Hey Kevin,

It sounds like you have a good start on your project. I
would suggest that you create a subform within your main
form to track the secondary set of data. When you place
the subform within your main form that is where you will
place the relationships between the first and second
table. Have you used subforms before?

Tony
 
I have two tables and two forms for entering information about work
experience students. 1st table contains personal details plus a start
and finish date. This info is entered via a form. The second table
contains fields for entry of two seperate dates and a team name. the
idea is that if a student is with us for 2 weeks he may spend 1 week
with one team and 1 week with another.
Click to expand...

The simplest way to deal with such a one-to-many relationship is to
use a Form for the "one" side - personal details - table, with a
Subform for the "many" - activities - table. If you use the person's
unique ID as the master/child link field it will fill in
automatically.
 
Back
Top