Hello Guys,
I have sample database in attachment. I am learning to thing in relational way in Access. Can you help me please?
I want to simplify my database from here:
https://www.access-programmers.co.uk/forums/showthread.php?t=293988
in order to understand step by step how to do things in Access in details.
Step 1
I have 2 tables:
1) EmployeeDocuments: Id Primary, DocumentName, DocumentID
2) Employees: Id_Primary, Person, JobPart
Relationships:
one to many (Employees.ID Primary as unique key and EmployeeDocuments.DocumentID is many relationships) ---> one Employee can have few different documents attached to him.
Thanks to it i can create simple Form (Form 1)
https://ibb.co/fdVkf5
where i can input data for each Employee (Job Part, Person are only one, but can be a lot of documents ).
Step 2 - first problem
I want to display on my form (Form 1) for each Person to have a datasheet view where people can input MANUALLY names of documents (these documents are similar and only some of them are the same).
So i would like to create a form on EmployeeDocuments table in order to prepare datasheetview, how to do it ?
I can quess that i should use combobox and bound it with person name?
Please People - help,
best Wishes,
Jacek
I have sample database in attachment. I am learning to thing in relational way in Access. Can you help me please?
I want to simplify my database from here:
https://www.access-programmers.co.uk/forums/showthread.php?t=293988
in order to understand step by step how to do things in Access in details.
Step 1
I have 2 tables:
1) EmployeeDocuments: Id Primary, DocumentName, DocumentID
2) Employees: Id_Primary, Person, JobPart
Relationships:
one to many (Employees.ID Primary as unique key and EmployeeDocuments.DocumentID is many relationships) ---> one Employee can have few different documents attached to him.
Thanks to it i can create simple Form (Form 1)
https://ibb.co/fdVkf5
where i can input data for each Employee (Job Part, Person are only one, but can be a lot of documents ).
Step 2 - first problem
I want to display on my form (Form 1) for each Person to have a datasheet view where people can input MANUALLY names of documents (these documents are similar and only some of them are the same).
So i would like to create a form on EmployeeDocuments table in order to prepare datasheetview, how to do it ?
I can quess that i should use combobox and bound it with person name?
Please People - help,
best Wishes,
Jacek