Help me please

[icemac]

I have 5 tables: 1. Student Information 2. Project Mid Table 3. Project Information 4. School Mid Table 5. School Information

Student information is linked to both of the mid tables and both of the mid tables are linked to their corresponding tables (project mid table - project information and school mid table - school information)

I enter the school information and project information seperatly. I enter the student information and what school each student goes to in another form (a form that includes fields from school mid table and student information). I want to do a similiar process when entering the students and the projects they have done (using student name from student information and fields from project mid table). However i do not want to enter new students into the database i only want to use the students that i entered earlier. Can anyone help me with this?

 

[waynewe]

What you need to do is get the existing student then add and data to the project table and ensure the foriegn key is the StudentId or StudentNum.

I am not sure of your ability however if you managed the first tasks can't see why this is a problem.

Just attached sub-forms (data-entry) off the master form like Student or have a maintenance form to allow project record entry by entering StudentId or StudentNum.

I hope this makes some sense.