Dear experts,
I'm trying to figure out how I can mark values as "available".
I have a list of 50 phonenumber which are available on our phone exchange.
I have this an excel where it shows the telephone numbers sorted and behind the number the name of the employee who has the number assinged.
There are 44 numbers assigned at the moment and 6 are available for future use and hence marked in the excel "available" instead of an employee name.
I'm tying to get this in Access but am struggling how to add this correctly as I made following tables for the communcition (to avoid blanc entries) and then ofcourse I can't select telephonenumbers from a preset table nor mark unassigned numbers as available....(??)
EmployeeT
EmployeeID
FirstNameFK
LastNameFK
UserIDFK
IsActive
CommunicationsT
EmployeeID
MethodID
Number
MethodT
MethodID
Method
Method being: HomeTel, WorkTel, MobileWork, MobilePrivate, Skype...
Can anyone shed a light?
Thanks.
Best regards,
Siegfried
I'm trying to figure out how I can mark values as "available".
I have a list of 50 phonenumber which are available on our phone exchange.
I have this an excel where it shows the telephone numbers sorted and behind the number the name of the employee who has the number assinged.
There are 44 numbers assigned at the moment and 6 are available for future use and hence marked in the excel "available" instead of an employee name.
I'm tying to get this in Access but am struggling how to add this correctly as I made following tables for the communcition (to avoid blanc entries) and then ofcourse I can't select telephonenumbers from a preset table nor mark unassigned numbers as available....(??)
EmployeeT
EmployeeID
FirstNameFK
LastNameFK
UserIDFK
IsActive
CommunicationsT
EmployeeID
MethodID
Number
MethodT
MethodID
Method
Method being: HomeTel, WorkTel, MobileWork, MobilePrivate, Skype...
Can anyone shed a light?
Thanks.
Best regards,
Siegfried