Access07: Hire Co : Create Hire tables
|MS Access <|
|Table of contents|
Entity Relationship diagrams
Which in MS-Access becomes (Entity/Attribute data dictionary follows)
- Client to Hire is an Access type 2 join "Include ALL records from tblClient ..."
- Equipment to Hire is an Access type 1 join "Only include rows where the joined fields from both tables are equal"
- When included in the overall Database for the Hire Center, a staff member will be responsible for the Hire, so StfID has been added to tblHire. Later this will be linked to the staff table. But for now, to keep things from getting too complicated this relationship will be added later.
Client table (is included in the accounts sub system)