Re: Link table fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I've got:
Tblemployee
EmployeeID
Surname
FirstName
Profession
Team
Specialty

TblCourse
CourseID
CourseName
CourseType
CourseDate

TblLink
EmployeeID
CourseID
Mandatory (Yes/No)
Notes

I like the idea of having the course date in the link table so I will
change that.
The profession, team and course names are accessed via a look-up table.
The thing is I made the employee form and subtable but the mandatory and
notes fields would not let me enter any data.

Thanks so much for your help.
"Ron2006" wrote:

The tables contain the data/information.

The forms (using the queries) allow you to see/add/change the data in
the tables.

So add the fields to the link table if it is relevent to the link
between the specific employee and that specific course, for instance
the date on which the course was taken or ended or started, or
registered, or as many events as you need to monitor.

Add to the course table if it is relevent to the course - the teacher
maybe or classroom or whatever.

Add to the employee table if it is relevent to the employee alone -
department, phone number, manager or whatever.

Then change the queries to include those needed fields for each of the
particular forms.

From that point we all need a little more information to give you some
more specific suggestions.

Ron

.

Relevant Pages

  • Re: Link table fields
    ... The forms allow you to see/add/change the data in ... Add to the course table if it is relevent to the course - the teacher ... Add to the employee table if it is relevent to the employee alone - ... Then change the queries to include those needed fields for each of the ...
    (microsoft.public.access.gettingstarted)
  • Re: Training DB Help
    ... manadatory flag (some classes are mandatory, ... What I am being asked to do now, is create a report that lists the employees ... this next query is supposed to look up all ... SELECT Employee.* ...
    (microsoft.public.access.queries)
  • Re: claim and remit social welfare benefits
    ... don't want the employee to double-dip, and so filing is mandatory. ...
    (alt.usage.english)
  • Re: Courses not yet attended
    ... Another query can get all the 'mandatory' classes (per employee), ... The query which shows what mandatory events employees have attended is ...
    (microsoft.public.access.queries)
  • Re: OT: Legal question
    ... I think that sucks big time. ... Maybe you can get them on the mandatory OT ... if you are not an employee it is legal to require it of? ... As far as the internship goes, you have no choice about doing that if ...
    (sci.med.transcription)