Hi to all
I am creating a database whose output is to be Excel data as shown below
I have several phases, nearly a hundred different items, several responsible and several additional documents.
I created tables for them. And I'm stuck.
When creating a new document, 100 rows are created in the table with the name (repeatable), phase (repeatable), item (unique), revision, etc.
When editing and creating a new revision, I need to add another line for item with a new date.
Normally one document should have 100 lines, but when editing and revising changes (even about 10) about 1000 lines are created for one document.
And now the question is, do you have any ideas for creating such documents in Access, and maybe I'm going the right way.
I am asking you for help and any ideas, experiences
Thank you
I am creating a database whose output is to be Excel data as shown below
I have several phases, nearly a hundred different items, several responsible and several additional documents.
I created tables for them. And I'm stuck.
When creating a new document, 100 rows are created in the table with the name (repeatable), phase (repeatable), item (unique), revision, etc.
When editing and creating a new revision, I need to add another line for item with a new date.
Normally one document should have 100 lines, but when editing and revising changes (even about 10) about 1000 lines are created for one document.
And now the question is, do you have any ideas for creating such documents in Access, and maybe I'm going the right way.
I am asking you for help and any ideas, experiences
Thank you