Creating a Link With Forms and Tables

S

smaley24

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
 
S

Sharkbyte

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
 
J

jahoobob

smaley24 said:
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
Click to expand...

I think I understand what you want.
You can use combo or list boxes in your form for the three databases
and select what you want in from each and store it in the fourth
database on which the form is based
 
Top