I am currently disigning a database.
I have the following tables:
tblManager:-
ManagerID
CompanyID
First Name
Surname
Email
tblCompany:-
CompanyID
Company
Region
Address_1
Address_2
Address_3
Address_4
Postal Code
Tel No.
Fax No.
Email
ManagerID
Extensions
Ad Tel No_1
Ad Tel No_2
Ad Tel No_3
Ad Tel No_4
Web
Speed Dial
tblEmployees:-
EmployeesID
CompanyID
ManagerID
Employee_1
Employee_2
Employee_3
Employee_4
Employee_5
Employee_6
I'm not sure exactly what route I go about sorting out a query. The relationships are obvious (I think).
Basically, I just want to be-able to create a database where it allows me to enter the relevent information regarding the company, management employees etc..
Preferably via using a form.
Can anyone give me any tips. I would be very greatful!!
I have the following tables:
tblManager:-
ManagerID
CompanyID
First Name
Surname
tblCompany:-
CompanyID
Company
Region
Address_1
Address_2
Address_3
Address_4
Postal Code
Tel No.
Fax No.
ManagerID
Extensions
Ad Tel No_1
Ad Tel No_2
Ad Tel No_3
Ad Tel No_4
Web
Speed Dial
tblEmployees:-
EmployeesID
CompanyID
ManagerID
Employee_1
Employee_2
Employee_3
Employee_4
Employee_5
Employee_6
I'm not sure exactly what route I go about sorting out a query. The relationships are obvious (I think).
Basically, I just want to be-able to create a database where it allows me to enter the relevent information regarding the company, management employees etc..
Preferably via using a form.
Can anyone give me any tips. I would be very greatful!!