RE: creating a new database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.


Duane Hookom wrote:
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!!!!

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: HELP NEEDED WITH AUDIT TRAIL
    ... my only convern is one of my table dont have Autonumber primary key because ... satisfy your condition of autonumber primary key. ...
    (microsoft.public.access.modulesdaovba)
  • RE: CANT see EDIT UPDATE CANCEL Buttons for DATAGRID
    ... For updating the SQL database using data grid, is primary key required? ... dont have a primary key in the SQl table. ... >> records are displayed where company name matches with user input. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Coding at table with multiple primary key columns
    ... Hey Andi, this solution does not work I am getting a Constraint error. ... I dont know if that makes a difference. ... the unique contraint do the same thing as the primary key. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2K3, SQL Server 2K5, "Instead of" Trigger Problem
    ... why dont you just use a simple integer as a PK ... and then you can take your extra special PK and shove it wherever you ... Sylvain Lafontaine ... the primary key of the primary table if the new row has a null value ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Clustered columns confusion
    ... "Chinmay" wrote in message ... > Yes and i dont have a Primary Key on Image column. ...
    (microsoft.public.sqlserver.server)