Hi, I am trying to create a database to record quality checks against each project. I have one table called "Projects" which contains all current project details and another called "Checks" which contains all quality checks required for each project, plus comments, dates etc.
Basically, I need a form to select a particular project from the "Projects" table which will then show me all the records from "Checks" table to allow me to tick them off/comment on them (every project needs the same checks carried out). The results need saved against the particular project.
I have tried to combine these tables with a query but I cannot edit the results on a form. I have tried creating an Append Query to transfer date into a new table which will let me change entries but if I add another record in "Projects" and run Append Query again it adds in the new record and duplicates all existing records. Also, any changes to the new table do not update on the "Projects" and "Checks" tables.
Hope this makes sense. Any help will be much appreciated.
Basically, I need a form to select a particular project from the "Projects" table which will then show me all the records from "Checks" table to allow me to tick them off/comment on them (every project needs the same checks carried out). The results need saved against the particular project.
I have tried to combine these tables with a query but I cannot edit the results on a form. I have tried creating an Append Query to transfer date into a new table which will let me change entries but if I add another record in "Projects" and run Append Query again it adds in the new record and duplicates all existing records. Also, any changes to the new table do not update on the "Projects" and "Checks" tables.
Hope this makes sense. Any help will be much appreciated.