Embedded Files
Fully attributed Entity Relationship Diagram
Fully attributed Entity Relationship Diagram
Now adding the attributes with Primary and foreign keys gives.
For this tutorial we will add the EmpID to the Carpark.
Creating a Carpark Table in MS-Access
Creating a Carpark Table in MS-Access
Create a Carpark table (tblCarpark)
Make sure you add the EmployeeID (EmpID). This will be a foreign key (belongs to the Employee table), PLUS must a a Number (Long Integer) as an AutoNumber is a Long Integer so when connecting two attributes they MUST BE the same data types.
Creating the relationship between Employee and Carpark
Creating the relationship between Employee and Carpark
As a carpark does NOT need to be assigned to an employee do NOT enforce referential integrity. So just drag this to the Relationship diagram and create the link (Make sure you drag from tblEmployee to tblCarpark (always drag from the PK to the FK)..
So how do we assign a carpark?
Probably the easiest way is to create a Carpark form and use a combo box to select the Employee.
Creating a Carpark Form
Creating a Carpark Form
This is a case where a datasheet form would be best.
So use the Create > Form Wizard
Select the Carpark table and select all fields
Select Tabiular view
Call the form frmCarpark
To simplify the entry of the Employee, it would be good to create a Combo (Drop down) text box.
Use Design view to add a combo Box to select the employees,
Select FormDesign> Controls (Combo Box)
Use Design view to add a combo Box to select the employees
Now
delete EmpID from the original form
delete the combo box label (Click on the labels large grey box (top left) and delete)
Move the cobo box to where the original EmpID Text box ws.
And you will now have a user friendly form that allow carparkes to be entered and if necessary assigned to employees
Google Sites
Report abuse