check box question

[Chimp8471]

i have 2 tables set up as follows,

Table 1

Employee Number - (PK)
Forename
Surname
Coach - Checkbox
(and a few other but these are the main ones)

Table 2

Employee Number - (PK)
Forename
Surname
Coach - Checkbox
Trainer - checkbox
(and a few others)

Table 1 is where the bulk of the employee data is stored, table 2 is where i keep a track of who is a coach and who is a trainer.

my question is:

is it possible that when i check the box in table to to indicate that the specified person is a coach, that the main records in table 1 also recieve a tick to highlight this fact

 

[Mile-O]

Your structure is wrong:


Table 1

Employee Number - (PK)
Forename
Surname
JobTypeID - (FK)

Table 2

JobTypeID- (PK)
JobType
Surname

 

[Mile-O]

A database should grow down, not by width.

If you kept your current structure going, you'd be adding job types all the time and having to rewrite parts of your database.

By making a table the way I've suggested you need to do the programming/designing only once and never look back as you can easily add job types into the field which can then be easily selected by listboxes, combos, etc.


Makes totalling with queries easier too.