Creating a Link With Forms and Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently making a database, with 4 Tables

I want the user to fill in first 3 tables, which will be Student, Lesson
and Instructor as normal, however, the fourth table will be created into a
form and is different. I want all the information from the 3 tables to be
inserted into the form when the user inserts the primary key numbers from
each record of the entities.

Can Any One Help

Do I need a Formula or VB Code
 
smaley:

Let me see if I understand what you are asking...

You want a person to enter info into tables:

tblStudent
StudentID (PK)

tblLesson
LessonID (PK)

tblInstructor
InstructorID (PK)

Then you want them to create a fourth table that will put all that
information on a form, together:

tblAll
StudentID
LessonID
InstructorID

That is what I am understanding you to say.

If so a question...

Is the same person entering all of the Student/Lesson/Instructor
information, for a single person? Doesn't have to be all, just that a person
opens the db adds a Student, their Lesson, and the Instructor of that lesson.

This, most likely, can all be done with much work. Just need a little more
information.

Sharkbyte
 
Back
Top