Relationship between tables

[S Tuttle]

I have made a master table that I have made relationships to the other table in the database. I want to be able to put a record in the master and it then go to the approiate table. Can some one please help me.

Also I want to create a search form. So when it come up the person types in the student first name and last name and it will bring up the entire record

 

[Jeff Boyce]

I'm not entirely clear on your data structure. Why are you trying to save a
record into more than one table? "... put a record in the master and it then
go to the approiate table."

Also I want to create a search form. So when it come up the person types

in the student first name and last name and it will bring up the entire
record

If you design a form to include a combo box, based on student names, your
user wouldn't even have to type -- and how were you going to handle someone
who mis-types a name? The basic approach is to have the user select a name
from the combo box, then get THAT record for display in the form.

Good luck

Jeff Boyce
<Access MVP>

 

[Tim Ferguson]

I have made a master table that I have made relationships to the other
table in the database. I want to be able to put a record in the
master and it then go to the approiate table. Can some one please
help me.

Ummm: this is not really the way that databases work. The idea is that
everything lives in one place in the design and there is never any "movng"
about.

For example, the Students table would have fields that relate directly to
the person: FName, LName, Address, and so on.

There would be another table that would hold details of the Registrations:
StudentID, CourseNumber, DateApplied, FeePaid, etc.

If the fees were to be paid in several installments, then you would take
FeePaid out of the Registations table and have instead a Payments table
like: StudentID, DateReceived, Amount, WhetherCleared, and so forth.

While it is not always easy to see what tables you need (and that is why
the analysts get the big bucks!), it is vital to get the design right
before doing any further coding because otherwise you will have to do it
all over again.

Hope that helps


Tim F