Relationships

[desperately seeking access]

i am in the process of creating a database for a detention system. The
database must allow me to access and get information about each learner in so
far as defaults and detention. My problem is not with what i would like to
retrieve BUT rather how to build my tables so the relationships work. Thus
far i have created all my tables , i am unsure of which table should have the
relational ID for me to get the correct information.

Table 1
LearnerID Primary Key
learnername
learnersurname

Table 2
DetentionID primary key
Detention
LearnerID (is this correct )

the problem that i have at the moment in addition to the above is that where
and how do i enter the information.

Help I'm desperate
Any suggestions that would solve my problems would help.

 

[Gina Whipp]

DSA,

A wee bit more information needed...

1. Are there set Detentions? ie, 1 day, 1 week, etc.???
2. What are defaults? Is it where a learner does not serve the detention?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"desperately seeking access"

 

[KARL DEWEY]

Based on what you posted you would use a form/subform for Detention/Learner
with LearnerID in subform combo box.
Use this as combo source --
SELECT [LearnerID], [learnername] & " " & [learnersurname] FROM Table1 ORDER
BY [learnersurname], [learnername];
Column Count 2
Column 1 bound
Column Widths 0"; 1.25"