creating a new database

[accessuser via AccessMonster.com]

hi, i am starting to create my second database but i am stuck with the
"relationship" joints and primary keys. I never used relationship before. I
appreciate for some guidelines in the relationship joint areas. This new
database is for storing Tuition Reimbursement information. I want to have a
subform within a form. I tried to make the table relationship joints work
for the past two days and still have no luck even with 3 books and
researching online.

In the tables, i want to be able to open up the master table with their names,
subsheets with course information, and the third subsheets with cost
information.

As for the Forms, I want to see pretty much the same thing as the table, with
their names on the top of the form, and then have a subform with their course
and cost information.

The fields name will be:
TblEmp
---EmpID
---FirstName
---LastName
---Degree Working Toward

TblCourseInfo
---SemesterYear <---------------------i want to be able to sort by year
and link it to the TblCost
---Educational Institution
---Semester
---Course Title
---Grade
---# of Credits

TblCost
---Course Cost
---Course Assistance
---Course Cost Difference
---Book Cost
---Book Assistance
---Book Cost Difference
---Fees
---Total Course and Book Cost
---Total Company Assistance


The TblCourse and Tblcost, which one should i set for primary key? They dont
look like something that i can set for primary key, they dont have OrderId or
anything unique in them.

What types of joint should I use, there are three options, and I really still
have no clue after reading 3 books, online research and staying up late. Do
I still need to link them in Queries?? Should I create form with Queries
jointed, or use jointed tables?

In the form, I would want to be able to add course and cost into it later on
when they sign up for new courses. but sometimes i got the error msg says
that I can't add because of index or primary key or something like that. So
now i want to start from zero with correct relationship joints.

Please help me to sort out this problem.

Thank you so much!!!!

 

[Duane Hookom]

I don't care much for some of your structure. How does tblEmp relate to any
of this?

I'm sure this isn't correct but I don't understand your requirements:
TblCourseInfo
---CourseID Autonumber Primary Key
---SemesterYear <----i want to be able to sort by year and link it to the
TblCost
---EducationalInstitution
---Semester
---CourseTitle
---Grade
---NumOfCredits

TblCost
---CostID autonumber primary key
---CourseID links to tblCourseInfo.CourseID
---CostType
---CostAssistance
---Fees

I would not store derived values and you should not store data values
"Course" and "Books" in field names.

 

[accessuser via AccessMonster.com]

thanks for your suggestions. but i am sorry, i dont understand what you mean
on the Course Title and Bookcost. when bringing up the employee profile, we
want to be able to view where they took class, what are their courses, cost
for each course, fees, and how much we paid. stuff like that

TblEmp is where I can create their name, we'd like to look up by their name.
if i dont link them to the courses and costs, how would we need what have
they taken and how much the company had paid???

I appreciate you taking the time to reply.

I don't care much for some of your structure. How does tblEmp relate to any
of this?

I'm sure this isn't correct but I don't understand your requirements:
TblCourseInfo
---CourseID Autonumber Primary Key
---SemesterYear <----i want to be able to sort by year and link it to the
TblCost
---EducationalInstitution
---Semester
---CourseTitle
---Grade
---NumOfCredits

TblCost
---CostID autonumber primary key
---CourseID links to tblCourseInfo.CourseID
---CostType
---CostAssistance
---Fees

I would not store derived values and you should not store data values
"Course" and "Books" in field names.

hi, i am starting to create my second database but i am stuck with the
"relationship" joints and primary keys. I never used relationship before. I

[quoted text clipped - 56 lines]

Thank you so much!!!!