I am creating a sample database and the work is so painful, I really wonder and need assistance to reduce my pain.
I would like to create a "lookup Field" which returns the value (string) automatically from another table.
Example,
I have 2 tables - Department and Employee
Department[DepartmentID, DepartmentName]
1 Accounting
2 Marketing
3 Sales
Employee[EmployeeID, EmployeeName DepartmentID, DepartmentName]
1 'John' 3 then it will automatically add "Sales" to DepartmentName field as EmployeeID = 3
2 'Peter' 1 then it will automatically add "Accounting" to DertpartmentName field as EmployeeID = 1
My second question is about automatically generate a list of different numbers and add to database table.
Example,
I have a table name call Employee with 3 fields
Employe[EmployeeID, EmployeeName, EmployeeSocialNumber]
1 John
2 Diane
3 Zhenge
If I run the code, then it automatically insert the EmployeeSocialNumber (incremented by 1) into the table
1 John 123-456-1000
2 Diane 123-456-1001
3 Zhenge 123-456-1002
?